Oracle移植到MySQL遇到的坑

Oracle在插入表的时候，表如果有自增长字段,
在oracle中是要写为–自增长字段.NEXTVAL,而MySQL需要将.NEXTVAL去掉

示例：
(Oracle): insert into table(id,name) values(id.NEXTVAL,‘test’)
(MySQL): insert into table(name) values(‘test’)

日期关键字:

(Oracle): Sysdate
(MySQL): Now()

to_date函数:

(Oracle):
SELECT * FROM JOBINF WHERE CTIME BETWEEN TO_DATE(‘2019-07-05 00:00:00’,‘yyyy-MM-dd HH24:MI:SS’) AND SYSDATE

(MySQL):
SELECT * FROM JOBINF WHERE CTIME BETWEEN ‘2019-07-05 00:00:00’ AND NOW()

存储过程语句需要将冒号改为问号才不会出错 “:” 改为 “?”

(Oracle): insert into table(name,id) values(:name,:id)
(MySQL):insert into table(name,id) values(?name,?id)

删除语句

(Oracle):delete table
(MySQL):delete from table