I have a quick question:
I have a table called mytable that has the following structure:
With the following rows:
id---vert_id----local_id 1 10 6 2 52 6 3 67 8
I want to run an insert like this:
I need mysql only to insert the ('10', '7') and not ('10', '6') because that pair already exists.
I tried using insert ingore, but since these aren't unique or primary indexes it doesn't work.
Any help would be greatly appreciated