mysql - MySQL : "Every derived table must have its own alias" 中的错误 1248

Question

我正在尝试运行此查询:

SELECT DISTINCT col1 
FROM 
  (
   SELECT CONCAT(retailerId,'_recharge') FROM retailerinformation
   WHERE Channel='videocon' AND retailerId='kioskpb20130909045617'
  )

但是每次运行我都会得到这个错误:

Error Code : 1248 Every derived table must have its own alias

Answer 1

你的错误很明显。创建别名:

SELECT DISTINCT 
  col1 
FROM 
  (select concat(retailerId,'_recharge') from retailerinformation where Channel='videocon' and retailerId='kioskpb20130909045617') AS tmp_table

提示:如果您尝试理解错误，而不仅仅是阅读它们 - 这将是成功的故事。