BPF, Thursday, November 21, 2002, 4:36:58 PM, you wrote: BW> CREATE TABLE `reg_member` ( BW> `account` bigint(20) NOT NULL auto_increment, BW> `userid` varchar(48) NOT NULL default 'Your name', BW> `uilogin` tinyint(4) NOT NULL default '0', BW> `id` varchar(48) NOT NULL default '', BW> `password` varchar(10) NOT NULL default '', BW> `joined` bigint(20) default NULL, BW> `expired` bigint(20) default NULL, BW> `status` varchar(20) NOT NULL default '', BW> PRIMARY KEY (`account`), BW> UNIQUE KEY `id` (`id`) BW> ) TYPE=MyISAM
I tested it with 3.23.53 and it worked fine for me: mysql> update `reg_member` set id=4 where id=2; ERROR 1062: Duplicate entry '4' for key 2 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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