求sql怎么一次用insert 添加多条数据

2025-02-25 19:32:59
推荐回答(2个)
回答1:

INSERT INTO `user` VALUES
('1', 'Jack', '123456', '13800000000', '2017-05-27', b'1'),
('2', 'Lucy', '123456', '15088888888', '2017-05-26', b'0'),
.
.
.
('10', 'Lucy', '123456', '15088888888', '2017-05-26', b'0');

回答2:

insert into