[PHP] R: [PHP][MySQL] FAKE DUPLICATE ROW

2004-02-20 Thread Alessandro Vitale
you are an angel, thanks for your great suggestion. cheers alessandro -Messaggio originale- Da: Richard Davey [mailto:[EMAIL PROTECTED] Inviato: venerdi 20 febbraio 2004 14.40 A: [EMAIL PROTECTED] Oggetto: Re: [PHP][MySQL] FAKE DUPLICATE ROW Hello Alessandro, Friday, February 20

Re: [PHP][MySQL] FAKE DUPLICATE ROW

2004-02-20 Thread Richard Davey
Hello Alessandro, Friday, February 20, 2004, 1:31:02 PM, you wrote: AV> `code` int(20) default NULL, AV> so that seems that mysql has created a completely wrong key for this row! AV> my question is: is there a limit for the integer part of the index, or a bug AV> any suggestion would be very m

[PHP][MySQL] FAKE DUPLICATE ROW

2004-02-20 Thread Alessandro Vitale
I have this table on my MYSQL 4.0.16 : CREATE TABLE `pls_in_row` ( `row_id` int(11) NOT NULL auto_increment, `pls_id` int(11) default NULL, `code` int(20) default NULL, `description` varchar(255) default NULL, `valid_from` date default NULL, PRIMARY KEY (`row_id`), UNIQUE KEY `pls_r