Home >Database >Mysql Tutorial >ERROR 1222 (21000): The used SELECT statements have a differ_MySQL
ERROR 1222 (21000): The used SELECT statements have a differ_MySQL
- WBOYOriginal
- 2016-06-01 13:21:051156browse
bitsCN.com
1) ERROR 1222 (21000): The used SELECT statements have a different number of columns :
这是因为使用union的两个SQL语句产生的记录的表结构不一致. 必须是结构完全一致的记录集合才可以使用UNION.
以上就是两个表的字段不一样，导致，所以大家可以检查下。bitsCN.com
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下为数据库设置交叉权限的方法_MySQLNext article：win2003 mysql单向同步配置步骤[已测]_MySQL