Open YogzZ opened 3 years ago
After I insert some data by "INSERT INTO t1 VALUES (3, 'Pear', 17, 1)", I try to use "INSERT INTO t1 VALUES (3, 'Pear', 18, 2)" to update this piece of data. But it doesn't work.
Is there any function like "unique key" to solve this problem?
Could you give me some advice?
After I insert some data by "INSERT INTO t1 VALUES (3, 'Pear', 17, 1)", I try to use "INSERT INTO t1 VALUES (3, 'Pear', 18, 2)" to update this piece of data. But it doesn't work.
Is there any function like "unique key" to solve this problem?
Could you give me some advice?