is insert based on select on one of the column in MySQL possible?

Viewed 4504

Is following insert based on select on one of the column possible in MySQL

INSERT INTO student_fees(id, name, fees) 
VALUES(1, SELECT name from students where student_id = 1, 200$) 

If yes then and example will really help.

-Thanks

3 Answers
Related