Try insert ignore. Check the manual page for insert syntax.
On Wednesday, July 7, 2004, at 05:22 PM, Matt Chatterley wrote:
This is certainly the first step.
Also, if you want to "insert only those rows which are not already
present",
you can use something akin to:
INSERT INTO table1
SELECT * FROM table2 t2
LEFT JOIN table1 t1 ON (unique row identifiers -- whatever these are
for
your data)
WHERE t1.XYZ IS NULL
(obviously put in the appropriate column names etc for your data
structure!)
Cheers,
Matt
-----Original Message-----
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: 07 July 2004 22:22
To: [EMAIL PROTECTED]
Subject: Re: INSERT DISTINCT?
Certainly, it's called making a unique index on the field(s) you want
to
keep
unique.
Hope that helps.
j----- k-----
On Wednesday 07 July 2004 12:48 pm, John Mistler said something like:
Is there a way to do an INSERT on a table only if no row already
exists
with the same info for one or more of the columns as the row to be
inserted? That is, without using a method outside SQL?
Thanks,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]