sql insert statement with nested select

Question

is it possible to do 1 sql statement (insert) which you duplicate one of the inserting value from another table and another value you hard code? for eg, profilepic, i want to duplicate the value from another table data. As for displayname, i would like to hard code. This is my sql statement:

  insert into registration (profilePic, displayname) 
    values ( (select profilePic from registration where userId = 143), 'abc'  );

Error message from mysql :

Error code:1093. You can't specify target table 'registration' for update in from clause.

Cameron Tinker · Accepted Answer · 2018-10-31 11:18:59Z

5

Using subqueries within the values clause will not work. You should use the following query instead:

insert into registration (profilePic, displayname) 
select (select profilePic from registration where userId = 143), 'abc'

edited Oct 31, 2018 at 11:18

answered Jul 20, 2016 at 9:47

Cameron Tinker

9,83710 gold badges48 silver badges88 bronze badges

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

Collectives™ on Stack Overflow

sql insert statement with nested select

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