Home >Database >Mysql Tutorial >ERROR 1222 (21000): The used SELECT statements have a differ
ERROR 1222 (21000): The used SELECT statements have a differ
- WBOYOriginal
- 2016-06-07 18:03:521565browse
mysql 提示SQL-ERROR summary different number of columns
1) ERROR 1222 (21000): The used SELECT statements have a different number of columns :这是因为使用union的两个SQL语句产生的记录的表结构不一致. 必须是结构完全一致的记录集合才可以使用UNION.
以上就是两个表的字段不一样，导致，所以大家可以检查下。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL 重装MySQL后, mysql服务无法启动Next article：SqlServer中的日期与时间函数