Sure: CREATE TABLE `reg_member` ( `account` bigint(20) NOT NULL auto_increment, `userid` varchar(48) NOT NULL default 'Your name', `uilogin` tinyint(4) NOT NULL default '0', `id` varchar(48) NOT NULL default '', `password` varchar(10) NOT NULL default '', `joined` bigint(20) default NULL, `expired` bigint(20) default NULL, `status` varchar(20) NOT NULL default '', PRIMARY KEY (`account`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM
A+ JM -----Original Message----- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 3:31 PM To: BPF Webmaster; MySQL Subject: Re: Duplicate key delete record with same key Hi, Could you give us SHOW CREATE TABLE your_table ? Greetings from France too ;) Jocelyn ----- Original Message ----- From: "BPF Webmaster" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 2:25 PM Subject: Duplicate key delete record with same key > Using PHP 4.2.3 with MySQL 3.23.52 > > Report: > ------- > - Table has 2 keys: 'account' as PRIMARY and 'id' as unique > - I make an SQL update on an existing a record with id="anid" setting > id="anotherid" but another record exists with id ="anotherid" > - The update is performed and the record already existing with > id="anotherid" is deleted!!! > > Expected behavior: > ------------------ > - Update failed with "Duplicate key attempt message" > I guess it's a bug, isn't it? > > The workaround is very easy but I really guess the behavior is weird. > > Greetings from France, > JM > > > --------------------------------------------------------------------- > 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 > > > > --------------------------------------------------------------------- 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