UUID not valid at this position (Mysql workbench)

Question

I was trying to create a table and in this I was using id attribute as UUID but it is showing error that it is not valid at this position it is expecting something else

CREATE TABLE  account (
a_id                    UUID                PRIMARY KEY,
a_hash                  VARCHAR(66)         NOT NULL,
a_email                 VARCHAR(500)        NOT NULL,
a_password              VARCHAR(60)         NOT NULL,
a_verification_key      UUID                NOT NULL,
a_disabled              BOOLEAN             DEFAULT FALSE NOT NULL,
a_verified              BOOLEAN             DEFAULT FALSE NOT NULL,
a_role                  VARCHAR(20)         NOT NULL,
a_created_at            TIMESTAMP           DEFAULT NOW() NOT NULL

);

Here a_id field is UUID type and a_verification_key is also UUID and it is giving me error in mysql workbench

UUID is a function not a datatype - try searching for mysql uuid. — P.Salmon, Jul 29 '19 at 07:07
you change the datatype to `VARCHAR()` from UUID as `UUID` can be used as datatype — Romil Patel, Jul 29 '19 at 07:15
@Patel Romil you are saying that I need to remove this UUID and change to varchar — Rajat Agrawal, Jul 29 '19 at 07:22
Possible duplicate of [Store UUID v4 in MySQL](https://stackoverflow.com/questions/43056220/store-uuid-v4-in-mysql) — Alan Hay, Jul 29 '19 at 07:46
Thanks @scaisEdge,@P.salmon,@Alan Hay for the help everyone I resolved my error — Rajat Agrawal, Jul 29 '19 at 08:55

Romil Patel · Accepted Answer · 2019-07-29T07:29:18.380

You can use UUID, specify columnDefinition to VARCHAR(255) or CHAR(16) or BINARY(16) using @Column, with this you can use the functionality of UUID. You may change strategy and generator as per your requirement

@Id
@GeneratedValue(generator = "uuid2")
@GenericGenerator(name = "uuid2", strategy = "org.hibernate.id.UUIDGenerator")
@Column(name = "a_id", columnDefinition = "VARCHAR(255)")
private UUID a_id;

Discussion Function UUID

UUID not valid at this position (Mysql workbench)

1 Answers1