-- 一次插入一条记录 INSERT INTO `表名` SET `name` = '张三', `age` = '18', `dep` = '技术部'; -- 一次插入多条记录 INSERT INTO `表名` (`name`, `age`, `dep`) VALUES ('张三', '18', '技术部'), ('李四', '19', '销售部'), ('王五', '20', '客服部');
Copyright © 2024 码农人生. All Rights Reserved