i have the following which works fine:
but im wondering how i can modify this to UPDATE the existing record if the data2 value already exists in the table (Column2)? To prevent duplicate data.
Column1 in the table is Auto Incrementing primary key
Column2 - i want this to stay unique i.e if...