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
