On Sunday 29 December 2002 15:06, Octavian Rasnita wrote:
>
> mysql> create table aaa(id int not null unsigned, name text);
>
> Can you tell me why doesn't it work?
>
null can't be signed or unsigned.
try int unsigned not null
Regards
Georg
filter: mysql, query
--
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?
>
Sure ! Your syntax
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 w
- 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
try:
create table aaa(id int(5) unsigned not null, name text);
not sure why but unsigned needs to come before not null.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Octavian Rasnita [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002