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