Re: which duplicate key was hit on last insert?

[yaya sirima]

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
-- 
Yaya SIRIMA
Engineer - Database Developer
+226 76868436
[EMAIL PROTECTED]