MySQL 报错

云博小周宇2024年5月5日2023年8月23日1 Min Read

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;