sql语句之insert into`[表名]`values();的2种写法:
CREATE DATABASE IF NOT EXISTS `test_coverDataBase`;
USE `test_coverDataBase`;
CREATE TABLE`test_surpman`(
`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT'超人id',
`surpmanCode` VARCHAR(15) NOT NULL COMMENT'超人编码',
`surpmanName` VARCHAR(20) NOT NULL COMMENT'超人名称',
`surpmanHome` VARCHAR(20) NOT NULL COMMENT'超人家园',
`createTime` DATETIME COMMENT'创建时间',
PRIMARY KEY(`id`),
KEY `index`(`surpmanName`)
)ENGINE=INNODB DEFAULT CHARSET=utf8;
#insert into 写法1
INSERT INTO`test_surpman` VALUES(DEFAULT,'chaoren','超人','地球','2022-8-11');
INSERT INTO`test_surpman`VALUES(DEFAULT,'tailuo','泰罗','银河M58星云','2022-8-11'); INSERT INTO`test_surpman`VALUES(DEFAULT,'gaiya','盖亚','光之国','2022-8-11');
#或者偷懒写法2
INSERT INTO`test_surpman` VALUES(DEFAULT,'chaoren','超人','地球','2022-8-11'), (DEFAULT,'tailuo','泰罗','银河M58星云','2022-8-11'),
(DEFAULT,'gaiya','盖亚','光之国','2022-8-11');