MYSQL - 插入两个值，其中另一个表的条件不起作用

Question

我正在尝试将两个值(一个是从具有条件的另一个表中选择的值)插入到一个表中......但下面返回一个错误:

SQL:

INSERT INTO animate_2 (number_records, type) 
     VALUES ((SELECT secty_cd, COUNT(*) 
              FROM securities 
              WHERE secty_cd = 'EQS'
             ), 'eqs'
            );

ERROR 1241 (21000): Operand should contain 1 column(s)

虽然子查询有效:

mysql> SELECT secty_cd, COUNT(*) FROM securities WHERE secty_cd = 'EQS';
+----------+----------+
| secty_cd | COUNT(*) |
+----------+----------+
| EQS      |    37316 |
+----------+----------+
1 row in set (0.00 sec)

我错过了什么？

Answer 1

这里不需要值，您可以像下面这样简单地编写查询。

INSERT INTO animate_2 (number_records,type) 
SELECT Count(*) , 'eqs'
FROM   securities 
WHERE  secty_cd = 'EQS'