[MySQL]出現錯誤 1248 — Every derived table must have its own aliasUna·FollowPublished inZero Code·Dec 3, 2020--ShareSELECT *FROM (SELECT * FROM `users`)執行子查詢時出現以下錯誤:1248 — Every derived table must have its own alias意似是每個生成的table都必須有自己的別名SELECT *FROM (SELECT * FROM `users`) AS U此時加上別名就解決了~~~