Re: No duplicate records, ignore
Table has 4 columns, id (autoincrement,primary,index), dt (datetime), temp (float), pres (float).
When the first bulk insert is made of 20 rows, there are no duplicates - ever. Those are accurate. The script checks an api call for the last 20 records without knowing when they update or how many new rows there are, so the call has to be made every hour. There may be 2 new rows or 8 new rows but only 20 max rows at a time. I only want to insert the new rows but the data I get from the API call is only dt, temp, pres (no primary index).
** There may be multiple records with the same dt AND the same temp, but never ALL 3 columns the same. But pres is NOT an index, primary, autoincrement.
I want to check each record against all three rows being the same, then insert if not.
Sorry if that's confusing.