mysql插入和删除多条

表结构

DROP TABLE IF EXISTS `record`;CREATE TABLE `record` (    `id` INT(32) UNSIGNED  NOT NULL AUTO_INCREMENT,    `name` VARCHAR(32) NOT NULL,    `created_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP)ENGINE=InnoDB DEFAULT CHARSET=utf8;desc record;

插入多条

INSERT INTO record (name) VALUES ('a'),('b'),('c');

删除多条

DELETE FROM record WHERE name IN ('a', 'b');DELETE FROM record WHERE name = 'a' or name = 'b';