Mybatis执⾏多条SQL(Mysql、Oracle)
Mybatis执⾏多条SQL(Mysql、Oracle)有必要学多门编程语言吗
mysql语句转oracleMysql:
数据连接开启多条语句处理
在url后⾯加⼊allowMultiQueries=true
万向节联轴器例:
url: jdbc:mysql://127.0.0.1:3306/user?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries= true`
//每条sql以分号结束
<delete id="delete">
delete from table1 where id = 1;
delete from table2 where id = 2;
<delete>prism constant什么意思
Oracle:
//每条sql以分号结束,end也是分号结束
<delete id = "delete">
begin
delete from table1 where id = 1;
mysql修改datadir无法启动delete from table2 where id = 2;
end;ios开发主要软件
<delete>
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。
发表评论