ERROR 1064 (42000) - ENUM
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!