Re: which duplicate key was hit on last insert?

Hi, CREATE TABLE Test ( COL1INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, COL2VARCHAR(10) NOT NULL, COL3VARCHAR(10) NOT NULL, UNIQUE(COL2, COL3); --(not that) FULLTEXT(col1,col2) ); Try this property FULLTEXT -- Yaya SIRIMA

Re: loading scripts to mysql

Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL PROTECTED] -- Yaya SIRIMA Engineer - Database Developer +226 76868436 [EMAIL PROTECTED]

Re: Group By and IF statement

at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Yaya SIRIMA Formateur - Database Developer +226 76868436 [EMAIL PROTECTED]