Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the problem of Mysql error Every derived table must have its own alias, the article is very detailed, has a certain reference value, interested friends must read it!

Mysql executes multi-table query Times error:

[SQL] SELECT * from (select e.account from employee eUNIONSELECT u.account from `user` uUNIONSELECT a.account from agent a) [Err] 1248-Every derived table must have its own alias

This means that each derived table must have its own alias.

This error usually occurs in a multi-table query or subquery, because in a nested query, the result of the subquery is queried as a derived table to the next level, so the result of the subquery must have an alias.

In the above example, modify the query statement:

SELECT * from (select e.account from employee eUNIONSELECT u.account from `user` uUNIONSELECT a.account from agent a) as total

As shown above, adding a sentence as total after the subquery is equivalent to aliasing the derived table of the result set of the subquery as total, and the problem is solved.

The above is all the contents of this article entitled "how to solve the problem of Mysql error Every derived table must have its own alias". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.