On Sun, Dec 29, 2002 at 04:06:39PM +0200, Octavian Rasnita wrote: > Hi all, > > I've tried the following SQL line in MySQL 4.05 for Windows and it told me > that there is an error starting from "unsigned...". > > mysql> create table aaa(id int not null unsigned, name text); > > Can you tell me why doesn't it work?
What is an 'unsigned not null'? The syntax calls for (col_name type [NOT NULL] ...). Two of the valid types are 'int' and 'int unsigned'. Try 'create table aaa(id int unsigned not null, name text);' -- "All government is, in its essence, organized exploitation, and in virtually all of its existing forms it is the implacable enemy of every industrious and well-disposed man." --- H. L. Mencken Rick Pasotto [EMAIL PROTECTED] http://www.niof.net --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php