MySql DB, help, sql error and i don't know why
| From: | David Rice | Date: | Tue, 21 Jan 2003 15:10:51 +0000 |
| Subject: | MySql DB, help, sql error and i don't know why | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25006@lists.php.net to get a copy of this message | ||
SQL-query :
CREATE TABLE
staff (
StaffId INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
Name VARCHAR( 30 ) NOT NULL ,
Surname VARCHAR( 30 ) NOT NULL ,
Address TEXT( 225 ) NOT NULL ,
JobId SMALLINT( 2 ) NOT NULL ,
PermissionId SMALLINT( 2 ) NOT NULL ,
HomePhone INT( 11 ) NOT NULL ,
MobilePhone INT( 11 ) NOT NULL ,
TipsPoints INT( 1 ) NOT NULL ,
DOB DATE NOT NULL ,
Password VARCHAR( 20 ) NOT NULL ,
ResterauntId INT( 1 ) NOT NULL ,
DateStarted DATE NOT NULL ,
StaffStatusId TINYINT( 1 ) NOT NULL
)
MySQL said:
You have an error in your SQL syntax near '(225) NOT NULL, JobId SMALLINT(2) NOT NULL, PermissionId SMALLINT(2) NOT NUL' at line 1
_________________________________________________________________
MSN 8: advanced junk mail protection and 2 months FREE*. http://join.msn.com/?page=features/junkmail