注册

达梦ignore语法改造

小灰灰_oO 2024/04/09 565 4

mysql支持update ignore语法,:

drop TABLE if EXISTS students; CREATE TABLE `students` ( `id` int NOT NULL, `name` varchar(50) DEFAULT NULL, `age` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `age` (`age`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
INSERT INTO students (id, name, age) VALUES (1, 'Alice', 18); INSERT INTO students (id, name, age) VALUES (2, 'Bob', 20); INSERT INTO students (id, name, age) VALUES (3, 'TOM', 19); mysql> SELECT * from students; +----+-------+------+ | id | name | age | +----+-------+------+ | 1 | Alice | 18 | | 2 | Bob | 20 | | 3 | TOM | 19 | +----+-------+------+

更新年龄

mysql> UPDATE IGNORE students -> SET age = 18 -> WHERE name = 'TOM'; Query OK, 0 rows affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 1 mysql> SELECT * from students; +----+-------+------+ | id | name | age | +----+-------+------+ | 1 | Alice | 18 | | 2 | Bob | 20 | | 3 | TOM | 19 | +----+-------+------+

想要将TOM的年龄改成18,碰到age字段的unique约束冲突,mysql会自动忽略该记录,不修改,并且也不报错。

达梦是否支持该语法,或者有办法改造么?

回答 0
暂无回答
扫一扫
联系客服