com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Every derived table must have its own alias
解决方法:
多表查询,必须设置别名。在ibatis框架中,“as t”必须写,例如:
select * from
(
select a.id,b.name from table_a a,table_b b where a.id=b.code
) as t
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Every derived table must have its own alias
解决方法:
多表查询,必须设置别名。在ibatis框架中,“as t”必须写,例如:
select * from
(
select a.id,b.name from table_a a,table_b b where a.id=b.code
) as t