MySQL INSERT statement for inserting dynamic and static values

Question

I would like run an INSERT statement to update a MySQL table with two values: The first value is pulled from a SELECT statement on a single column in another table. The second value I would like to be static.

Here is a generic example of what I'm working with:

INSERT INTO employee(id,salary) SELECT id,salary FROM contractor;

However, I would like salary to be a fixed, static value. We'll use '50000' as that static value. So here is a rough version of what I think the final statement would look like:

INSERT INTO employee(id,salary) SELECT id FROM contractor, '50000';

Am I on the right path with this? Thanks.

ScaisEdge · Accepted Answer · 2016-07-22 17:04:38Z

3

You can do this way (the resulting value must be in select clause)

INSERT INTO employee(id,salary) SELECT id, 5000 FROM contractor;

answered Jul 22, 2016 at 17:04

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

MySQL INSERT statement for inserting dynamic and static values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related