Hello.
You may execute select statement similar to this one to determine that you already have rows with keys you want to insert: select * from subscriber where phplib_id='val1',$USERCOL='val2',domain='val3'; Where val1,val2,val3 - values from corresponding insert query. szj <[EMAIL PROTECTED]> wrote: > Hi: > I am using MySQL under FC2 on Intel P4. I created one table using > the following command > > CREATE TABLE subscriber ( > phplib_id varchar(32) NOT NULL default '', > $USERCOL varchar(64) NOT NULL default '', > domain varchar(128) NOT NULL default '', > password varchar(25) NOT NULL default '', > first_name varchar(25) NOT NULL default '', > last_name varchar(45) NOT NULL default '', > phone varchar(15) NOT NULL default '', > email_address varchar(50) NOT NULL default '', > datetime_created datetime NOT NULL default '0000-00-00 00:00:00', > datetime_modified datetime NOT NULL default '0000-00-00 00:00:00', > confirmation varchar(64) NOT NULL default '', > flag char(1) NOT NULL default 'o', > sendnotification varchar(50) NOT NULL default '', > greeting varchar(50) NOT NULL default '', > ha1 varchar(128) NOT NULL default '', > ha1b varchar(128) NOT NULL default '', > allow_find char(1) NOT NULL default '0', > timezone varchar(128) default NULL, > rpid varchar(128) default NULL, > domn int(10) default NULL, > uuid varchar(64) default NULL, > UNIQUE KEY phplib_id (phplib_id), > PRIMARY KEY ($USERCOL, domain), > KEY user_2 ($USERCOL) > ) > which is in the SER package. After create the database and the table. I > login and insert some data into it. I can only insert one item into. > After that > I can't insert anymore. the error report is in the subject of this letter. > But it worked well last days , I have tested several times. Now it > refuse > to accept more than one . What happened to that??? > > Thanks you for your kind instruction > Best Regards. > Sun Zongjun > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
