当前位置：首页 > 数据库 > 正文

MySQL 报错

SELECT COUNT(1) FROM
(select tid from teacher where tname like ‘李%‘)

1248 - Every derived table must have its own alias, Time: 0.000000s

要给子查询的表加一个伪名

SELECT COUNT(1) FROM
(select tid from teacher where tname like ‘李%‘) as fuck;