Mysql和oracle区别:
1. 分页查询;
mysql: limit关键字
oracle: rownum字段
2. 批量操作:
mysql:
① insert into table (...) values (...), (...) ...;
② 需要allowMultiQueries=true:
insert into table (...) values (...);
insert into table (...) values (...); ...
数据库URL
allowMultiQueries=true: 支持按照";"批量操作
oracle :
① begin
insert into table (...) values (...);
insert into table (...) values (...); ...
end;
② 利用中间表
insert into table (...)
select ...
from (
select ... from dual
union
select ... from dual
union
select ... from dual
...
1. 分页查询;
mysql: limit关键字
oracle: rownum字段
2. 批量操作:
mysql:
① insert into table (...) values (...), (...) ...;
② 需要allowMultiQueries=true:
insert into table (...) values (...);
insert into table (...) values (...); ...
数据库URL
allowMultiQueries=true: 支持按照";"批量操作
oracle :
① begin
insert into table (...) values (...);
insert into table (...) values (...); ...
end;
② 利用中间表
insert into table (...)
select ...
from (
select ... from dual
union
select ... from dual
union
select ... from dual
...
)