Hi Everyone, I have just installed mysql 4 on a Linux server & I'm comparing it against MS-SQL to see it handles one of our DBs better. The DB has over 8 million records & MS-SQL shokes with it.
I have a field defined to be UNIQUE and I need to append from another table into it from MS-ACCESS 2000 (using myodbc). My problem is that MS-ACCESS stops when it finds a duplicate record. I need it to IGNORE & continue. It does not allow me to insert the keyword IGNORE (it gives me a syntax error) If I do it at the server I have no problem because I have the IGNORE option. Is there a way to formulate the SQL from MS_ACCESS to allow me to ignore duplicate records & insert the others? Or is there a switch on mysqld or myodbc that will allow me to do it? Thanks in Advanced, Dante --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php