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