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

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:

URL: 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

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