Can anyone help with this one?
MySQL said: You have an error in your SQL syntax near 'user(username VARCHAR(20) NOT NULL ,password VARCHAR(20) NULL ,expirydate DATE' at line 1.
Query: CREATE TABLE user(username VARCHAR(20) NOT NULL ,password VARCHAR(20) NULL ,expirydate DATE NULL ,timein VARCHAR(20) NULL ,stateid VARCHAR(20) NULL ,activate SMALLINT NULL )
MySQL said: You have an error in your SQL syntax near 'user(username VARCHAR(20) NOT NULL ,password VARCHAR(20) NULL ,expirydate DATE' at line 1.
Query: CREATE TABLE user(username VARCHAR(20) NOT NULL ,password VARCHAR(20) NULL ,expirydate DATE NULL ,timein VARCHAR(20) NULL ,stateid VARCHAR(20) NULL ,activate SMALLINT NULL )