🖥

MySQL — Error When Subquery Is Not AS | Every derived table must have

2019/04/16に公開

problem

For example, if you write a subquery like this, you get angry.

 SELECT * FROM ( SELECT User from user ); 

 => ERROR 1248 (42000): Every derived table must have its own alias

Give some table name (alias name) in AS.

 SELECT * FROM ( SELECT User from user ) AS account; 

 +-----------+ | User | +-----------+ | mysql.sys | | root | +-----------+

If you do not write AS, SQL is interpreted syntactically like "FROM (without table name)".

何か質問、悩み事、相談などあればLINEオープンチャットもご利用ください。

2019-04-16