I need to execute an INSERT...SELECT query.
INSERT HIGH_PRIORITY INTO stations_data
(station_id,
Tmin,
Tmax,
Tmed,
RHmin,
RHmax,
RHmed,
rain,
Wmax,
slpres,
insertion_date)
(
SELECT
stations.station_id AS stId,
min(stations_rt_data.T) AS tmax,
d. The
> only way I know to get around this is to pull the entire column(s) into
> memory and insert them back in one by one with a repeating INSERT
> statement. Can anyone tell me the "easy" way to do this? (I assume there
> must be a better way) Thanks!
Use IGNORE keyword in
On 19 Dec 2002, at 12:19, Andrew Kuebler wrote:
> When I run an INSERT. SELECT query and I am inserting the records into a
> new table that has a UNIQUE key, the statement will fail as soon as it
> hits a "Duplicate entry" error.
You probably want to use "INSERT IGNORE":
http://www.mysql.com/
At 12:19 -0500 12/19/02, Andrew Kuebler wrote:
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a "Duplicate entry" error. No further entries will be inserted. The
only way I know to get around this
When I run an INSERT. SELECT query and I am inserting the records into a
new table that has a UNIQUE key, the statement will fail as soon as it
hits a "Duplicate entry" error. No further entries will be inserted. The
only way I know to get around this is to pull the entire column(s) into
memory and