Re: MySql DB, help, sql error and i don't know why

use Address TEXT NOT NULL , Jochem David Rice wrote:

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