MySQL Forums
Forum List  »  Newbie

ERROR 1064 (42000) - ENUM
Posted by: Gustavo Rubio
Date: July 30, 2020 09:58AM

Hi

I create the following table and constatly I have an error with column: numbers ENUM(‘0’,’1’,’2’)
I changed values, name of the column, format and it doesn't work yet

ysql> CREATE TABLE operations (
-> operation_id INTEGER UNSIGNED PRIMARY KEY AUTO_INCREMENT,
-> book_id INTEGER UNSIGNED,
-> client_id INTEGER UNSIGNED,
-> numbers ENUM(‘0’,’1’,’2’),
-> created_at TIMESTAMP NOT NULL DEFAULT
-> CURRENT_TIMESTAMP,
-> updated_at TIMESTAMP NOT NULL DEFAULT
-> CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-> Finished TINYINT (1) NOT NULL
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘0’,’1’,’2’),
created_at TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAM' at line 5

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1064 (42000) - ENUM
July 30, 2020 09:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.