MYSQL - Insert of two values with where condition of another table not working

Question

I'm trying two insert two values (one is a select from another table with a condition) into a table ... but the below returns me an error:

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)

The subquery works though:

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

What am I missing?

PSK · Accepted Answer · 2018-05-30 08:36:44Z

2

You don't need values here, you can simply write your query like following.

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

answered May 30, 2018 at 8:36

PSK

18k5 gold badges35 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gordon Linoff Over a year ago

This is much the better answer.

Red Boy · Accepted Answer · 2018-05-30 08:39:24Z

1

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

To

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

answered May 30, 2018 at 8:39

Red Boy

5,7893 gold badges35 silver badges49 bronze badges

Collectives™ on Stack Overflow

MYSQL - Insert of two values with where condition of another table not working

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related