Insert data into table with result from another select query for one column

Question

INSERT INTO master_table (`Group_No`, `Group_Name`,`Order_No`) VALUES (6,'Purchase Account','SELECT Order_no FROM acc_group_master where Group_No=1')

How can i insert data into Order_No column.

Sachin · Accepted Answer · 2013-06-04 10:58:43Z

1

You can try this

INSERT INTO master_table (`Group_No`, `Group_Name`,`Order_No`)
SELECT 6,'Purchase Account',Order_no FROM acc_group_master where Group_No=1

answered Jun 4, 2013 at 10:58

Sachin

41.1k7 gold badges94 silver badges107 bronze badges

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

Comments

zkanoca · Accepted Answer · 2013-06-04 10:59:19Z

0

INSERT INTO master_table (`Group_No`, `Group_Name`,`Order_No`) VALUES
(SELECT 6, 'purchase Account', Order_no FROM acc_group_master where Group_No=1)

answered Jun 4, 2013 at 10:59

zkanoca

10k10 gold badges55 silver badges99 bronze badges

Comments

echo_Me · Accepted Answer · 2013-06-04 10:59:52Z

0

try this

INSERT INTO master_table (`Group_No`, `Group_Name`,`Order_No`) VALUES 
(6,'Purchase Account',(SELECT Order_no FROM acc_group_master where Group_No=1))

answered Jun 4, 2013 at 10:59

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Comments

Fabio · Accepted Answer · 2013-06-04 11:07:33Z

0

You have surrounded your subquery with quotes '..' wich make it becomes a string and been inserted as it is in your database, simply remove quotes and apply brackets instead

INSERT INTO master_table (`Group_No`, `Group_Name`,`Order_No`) 
VALUES (6,'Purchase Account',(SELECT Order_no FROM acc_group_master where Group_No=1))

edited Jun 4, 2013 at 11:07

answered Jun 4, 2013 at 10:58

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Collectives™ on Stack Overflow

Insert data into table with result from another select query for one column

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related