- 指定字段值插入
insert all
into test_insert(user_name,address) values('aaa','henan')
into test_insert(user_name,address) values('bbb','shanghai')
into test_insert(user_name,address) values('ccc','beijing')
select * from dual;
- 全部插入
insert all
into test_insert values('aaa','henan')
into test_insert values('bbb','shanghai')
into test_insert values('ccc','beijing')
select * from dual;