orcale insert 插入多条数据用法
1 insert all 2 into user (name,sex,score) values ('小明','男',80) 3 into user (name,sex,score) values ('小明','男',80) 4 into user (name,sex,score) values ('小明','男',80) 5 select * from dual;
第五行是必须要加的，不加报错，这是orcale的固定写法
1 insert all 2 into user (name,sex,score) values ('小明','男',80) 3 into user (name,sex,score) values ('小明','男',80) 4 into user (name,sex,score) values ('小明','男',80) 5 select * from dual;
第五行是必须要加的，不加报错，这是orcale的固定写法
浙公网安备 33010602011771号