re: info about an old version (v. 3.22.32)

2002-11-28 Thread Egor Egorov 
Marco,
Thursday, November 28, 2002, 3:36:22 PM, you wrote:

MAS> One of my friend, with MySQL v. 3.22.32 and with this commands :

MAS> CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
MAS> varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))

MAS> have this error:

MAS> MySQL complains:
MAS> Column 'con' is used with UNIQUE or INDEX but is not defined as NOT
MAS> NULL


MAS> I have v. 3.23.53-log  and with the same statment I have no error; I
MAS> guess because the new version add 'not null' automagically. 

MAS> Is it right?

Yes, exactly.

MAS> Can someone tell me from which version is it true?

>From the change logs:

 Using AUTO_INCREMENT will now automatically make the column NOT NULL.

 http://www.mysql.com/doc/en/News-3.23.0.html




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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

Re: info about an old version (v. 3.22.32)

2002-11-28 Thread Roger Baklund 
* Marco Andriolo-Stagno 
> One of my friend, with MySQL v. 3.22.32 and with this commands :
> 
> CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
> varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))
> 
> have this error:
> 
> MySQL complains:
> Column 'con' is used with UNIQUE or INDEX but is not defined as NOT
> NULL
> 
> 
> I have v. 3.23.53-log  and with the same statment I have no error; I
> guess because the new version add 'not null' automagically. 
> 
> Is it right?

Yes.

> Can someone tell me from which version is it true?

>From 3.23.0:

http://www.mysql.com/doc/en/News-3.23.0.html >

-- 
Roger

-
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

info about an old version (v. 3.22.32)

2002-11-28 Thread Marco Andriolo-Stagno 
Hi.

One of my friend, with MySQL v. 3.22.32 and with this commands :

CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))

have this error:

MySQL complains:
Column 'con' is used with UNIQUE or INDEX but is not defined as NOT
NULL


I have v. 3.23.53-log  and with the same statment I have no error; I
guess because the new version add 'not null' automagically. 

Is it right?

Can someone tell me from which version is it true?

thank you in advance!

bye bye!

  MAS!


-- 
Marco Andriolo-Stagno (MAS!) <[EMAIL PROTECTED]>
 PROSA  - free software - http://www.prosa.it
FreeGO! - free software news - http://www.freego.it

-
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