Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

Create Table Error

Jul 13, 2002, 10:07 AM
garris
New User (4 posts)
Jul 13, 2002, 10:07 AM
Views: 3684
Shortcut
Quote Reply
Create Table Error
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 )

Frown
Subject Author Views Date
Thread Create Table Error garris 3684 Jul 13, 2002, 10:07 AM
Thread Re: [garris] Create Table Error 		Paul 3626 Jul 13, 2002, 10:29 AM
Thread Re: [Paul] Create Table Error 		garris 3627 Jul 13, 2002, 10:47 AM
Post Re: [garris] Create Table Error 		garris 3616 Jul 13, 2002, 5:31 PM