DELETE FROM unique_table4;
INSERT INTO unique_table4 VALUES(1,‘aaaa’);
INSERT INTO unique_table4 VALUES(2,‘bbbb’);
INSERT INTO unique_table4 VALUES(3,‘cccc’);
…
UPDATE unique_table4 SET name = ‘Yuan’ WHERE id = 2;
- SUCCESS
- FAILURE
– below are some requests executed before(partial) –
– init
CREATE TABLE unique_table1(id int, col1 int, col2 int);
CREATE TABLE unique_table2(id1 int, id2 int, col1 int, col2 int);
CREATE TABLE unique_table3(id1 int, id2 int, col1 float, col2 char(4));
CREATE TABLE unique_table4 (id INT, name CHAR(4));
INSERT INTO unique_table1 VALUES (1,1,1);
…
25年比赛的这个测试样例通过不了，但在训练营里都是可以通过unique功能的，求助这是为什么啊？