Insert selection mariadb query

Question

I am trying to insert into table A where one of it's value need to be selected from table B. I used the below query.

INSERT INTO `TableA` (`TableACol1`,`TableACol2`) VALUES ( 4, SELECT `TableBcol1` FROM `TableB` WHERE FirstName="shasha" )

I don't know what's going wrong with this but facing this error.

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax

score 2 · Answer 1 · edited Mar 19 '19 at 13:47

2

Insert the "4" inside the select

INSERT INTO `TableA` (`TableACol1`,`TableACol2`)
SELECT 4, `TableBcol1` FROM `TableB` WHERE FirstName="shasha"

edited Mar 19 '19 at 13:47

cf_en

answered Mar 19 '19 at 13:39

Roy Bogado

Thanks @Roy . This one worked I just missed bunch of parenthesis. INSERT INTO `TableA` (`TableACol1`,`TableACol2`) VALUES ( 4, (SELECT `TableBcol1` FROM `TableB` WHERE FirstName="shasha" )) – shashank Mar 19 '19 at 13:49
Your link helped me Thanks @Roy – shashank Mar 19 '19 at 13:53
1

@shasha Nice, good coding! – Roy Bogado Mar 19 '19 at 13:56

1 Answers1