mysql - 谁能帮我看看这个 SQL 查询

Question

我试图在 SQL 中创建一个临时表，但出现了一个我无法识别的错误。

CREATE TEMPORARY TABLE Guest(ID INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
ticket_id NOT NULL VARCHAR(255),
event_id NOT NULL INT (11),
user_id NOT NULL INT (11),
fullname NOT NULL VARCHAR(255),
delivery NOT NULL VARCHAR(255),
ticket_type NOT NULL VARCHAR(255),
ticket_price NOT NULL DECIMAL(19,4),
fees NOT NULL DECIMAL(19,4),
total_price NOT NULL DECIMAL(19,4),
barcode NOT NULL VARCHAR(255),
purchase_time NOT NULL datatime,
person_pickup NOT NULL varchar(80),
Qty NOT NULL INT(11));

这是错误信息:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to usenear 'NOT NULL VARCHAR(255),event_id NOT NULL INT (11),user_id NOTNULL INT (11),fulln' at line 1

Answer 1

1 - 将“NOT NULL”放在字段类型之后:

CREATE TEMPORARY TABLE Guest(ID INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
ticket_id  VARCHAR(255) NOT NULL,
event_id  INT (11) NOT NULL,
user_id  INT (11) NOT NULL,
fullname  VARCHAR(255) NOT NULL,
delivery  VARCHAR(255) NOT NULL,
ticket_type  VARCHAR(255) NOT NULL,
ticket_price  DECIMAL(19,4) NOT NULL,
fees  DECIMAL(19,4) NOT NULL,
total_price  DECIMAL(19,4) NOT NULL,
barcode  VARCHAR(255) NOT NULL,
purchase_time  datetime NOT NULL,
person_pickup  varchar(80) NOT NULL,
Qty  INT(11) NOT NULL);

2 - 你在“DATETIME”上有错字