mysql与oracle语法差异、处理
统计查询结果条数报错
Every derived table must have its own alias 子查询增加别名
原sql
select count(1) from (" + sqlcmd + “)
新sql
select count(1) from (” + sqlcmd + ") as temptable
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
sql语法错误,大小写、语法迁移不兼容等
mysql区分表大小写
Table ‘*.*’ doesn’t exist
mysql表名需要与数据库表中一致