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

Solution

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オープンチャットもご利用ください。