MySQL与Oracle同时插入多条数据的sql书写方式不同,具体书写格式如下:
mysql一次插入多条数据
insert into t_studen (ID,STUDENT_NUMBER,NAME,AGE)
VALUES('1','20180001','张三',18),('2','20180002','李四',19),('3','20180003','王五',20)
oracle一次插入多条数据
insert all
into t_studen (ID,STUDENT_NUMBER,NAME,AGE) VALUES('1','20180001','张三',18)
into t_studen (ID,STUDENT_NUMBER,NAME,AGE) VALUES('2','20180002','李四',19)
into t_studen (ID,STUDENT_NUMBER,NAME,AGE) VALUES('3','20180003','王五',20)
select * from dual;