Hal Vaughan <[EMAIL PROTECTED]> wrote on 24/08/2005 17:41:36:
#>
> Okay, so INSERT IGNORE only works if I am avoiding duplicate keys. Is
there
> any way to use INSERT the way I thought INSERT IGNORE worked -- in other
> words is there any keyword for the INSERT command to keep it from
duplicating
> rows if there isn't a key?
I don't think so. But may I inquire why you do not want to have a key?
What you are saying is "How can I do a job without using the tool designed
for the job?". If there is no key, in order to do what you want, MySQL
would have to do a linear search through the table in order to check for
duplicates - the kind of lengthy operation it is designed to avoid
whenever possible. The key is a necessary part of the effect you want to
achieve.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
