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
8:07 AM
To: [EMAIL PROTECTED]
Subject: Why "unsigned" doesn't work?
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 te
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?
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email