I’m stuck.
Error Mssg: Table creation failed: (1064) 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 ‘YES NULL, first_name varchar(20), last_name varchar(40), address1 varch’ at line 3
The line referenced is in the email descriptor line of the following script …
[php] if (!$mysqli->query(“DROP TABLE IF EXISTS test1”)
||
!$mysqli->query(“CREATE TABLE test1(
id INT unsigned NOT NULL AUTO_INCREMENT,
email varchar(40) YES NULL,
first_name varchar(20),
last_name varchar(40),
address1 varchar(100) YES NULL,
address2 varchar(100) YES NULL,
city varchar(50) YES NULL,
state varchar(6) YES NULL,
zip varchar(12) YES NULL,
country varchar(6) YES NULL,
invoiceNo varchar(20) YES NULL,
USIT_txt unum(‘True’,‘False’) YES FALSE,
updated timestamp DATE,
created timestamp YES 0000-00-00 00:00:00,
PRIMARY KEY (invoiceNO),
INDEX (id)
)”) [/php]
near ‘YES NULL’ is the middle of the email descripter line.
I’ve exchanged this line with other in the same listing and each throws the same error with respect to the line following ‘id INT …’
I simply can’t see the syntax error.
any help will be much appreciated,
usit