mysql insert into copy one record

Question

Is it possible to insert a new row in mysql, with just one value copied from the database, and the other values provided directly?

I want to be able to do something like this:

INSERT INTO table (col1,col2,col3) VALUES(val1,val2,(SELECT col3 FROM table WHERE col1=val11 AND col2=val22))

Any ideas?

http://www.robsearles.com/2009/04/05/mysql-insert-with-a-select-subquery/ — Ruben, Jun 17 '11 at 10:05

score 1 · Answer 1 · answered Jun 17 '11 at 10:08

1

If you specify the values directly within the query you could go with.

INSERT INTO table (col1,col2,col3) SELECT 'val1', 'val2', col3 FROM table WHERE col1='val11' AND col2='val22';

answered Jun 17 '11 at 10:08

DanielB

Gryphius · Answer 2 · 2011-06-17T10:09:28.643

0

insert into t1 (col1,col2,col3) VALUES ('hello','world',(select col2 from t2 where id=1));

Query OK, 1 row affected (0.00 sec)

edited Jun 17 '11 at 10:09

answered Jun 17 '11 at 10:03

Gryphius

2 Answers2