search

hanchuanchuan / goInception

一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
https://hanchuanchuan.github.io/goInception/
GNU General Public License v3.0
1.59k stars 545 forks source link

创建视图包含以下语句报错Column 'num' in field list is ambiguous. #622

Open zmix999 opened 8 months ago

zmix999 commented 8 months ago

描述 对问题简单清晰的描述 创建视图包含以下语句报错 ( select * from test where id in ( SELECT max(id) FROM test where num is not null group by num ) ) image