----- Original Message ----- From: "Octavian Rasnita" <[EMAIL PROTECTED]>
> mysql> create table aaa(id int not null unsigned, name text); > Can you tell me why doesn't it work? You want: create table aaa(id int unsigned not null, name text); Your way doesn't work as 'unsigned' is a modification of the type, and so needs to be next to the type declaration 'int'. sql, query, anti-spam splooge. --------------------------------------------------------------------- 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