[MySQL]出現錯誤 1248 — Every derived table must have its own alias

Una
Zero Code
Published in
Dec 3, 2020
SELECT 
*
FROM (SELECT * FROM `users`)

執行子查詢時出現以下錯誤:

1248 — Every derived table must have its own alias

意似是每個生成的table都必須有自己的別名

SELECT 
*
FROM (SELECT * FROM `users`) AS U

此時加上別名就解決了~~~

--

--