mysql插入和删除多条

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';