Re: which duplicate key was hit on last insert?

[Lev Lvovsky]

On Nov 13, 2007, at 1:25 AM, yaya sirima wrote:
Hi,


CREATE TABLE Test (
        COL1    INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
        COL2    VARCHAR(10) NOT NULL,
        COL3    VARCHAR(10) NOT NULL,
   ---- UNIQUE(COL2, COL3);  ------(not that)


            FULLTEXT(col1,col2)


);



Try this property FULLTEXT

The columns here were used as an illustration of the two different  
types of duplicate keys which might have been hit.  We use UNIQUE  
constraints to include binary, int's, etc...

thank you for the info however, it may be useful elsewhere.

-lev

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]