我正在尝试在一个表中插入两个值(一个是从另一个带有条件的表中选择的值)。。。但下面返回一个错误:
sql语句:
INSERT INTO animate_2 (number_records, type)
VALUES ((SELECT secty_cd, COUNT(*)
FROM securities
WHERE secty_cd = 'EQS'
), 'eqs'
);
错误1241(21000):操作数应包含1列
但子查询仍然有效:
mysql> SELECT secty_cd, COUNT(*) FROM securities WHERE secty_cd = 'EQS';
+----------+----------+
| secty_cd | COUNT(*) |
+----------+----------+
| EQS | 37316 |
+----------+----------+
1 row in set (0.00 sec)
我错过了什么?
2条答案
按热度按时间jqjz2hbq1#
改变这个
INSERT INTO animate_2 (number_records, type) VALUES ((SELECT secty_cd, COUNT(*) FROM securities WHERE secty_cd = 'EQS'), 'eqs');
至INSERT INTO animate_2 (number_records, type) VALUES ((SELECT COUNT(*) FROM securities WHERE secty_cd = 'EQS'), 'eqs');
jm81lzqq2#
这里不需要值,只需编写如下查询即可。