[Err] 1248 - Every derived table must have its own alias
每个派生表都需要拥有别名
错误出处:
mysql
错误语句:
SELECT COUNT(*) FROM(SELECT * FROM table GROUP BY info_id)
修正语句:
SELECT COUNT(*) FROM(SELECT * FROM table GROUP BY info_id) AS t1