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

Reply via email to