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
