SELECT
COUNT(*)
FROM (SELECT *
FROM tcoupon
COUNT(*)
FROM (SELECT *
FROM tcoupon
LIMIT 9,21)
报错:
错误码: 1248
Every derived table must have its own alias:这句话的意思是说每个派生出来的表都必须有一个自己的别名
SELECT
COUNT(*)
FROM (SELECT *
FROM tcoupon
LIMIT 9,21) s
sql正确,(*^__^*) 嘻嘻……