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
