title: is insert based on select on one of the column in MySQL possible?
body: <p>Is following insert based on select on one of the column possible in MySQL    </p>
  
  <pre><code>INSERT INTO student_fees(id, name, fees) 
  VALUES(1, SELECT name from students where student_id = 1, 200$) 
  </code></pre>
  
  <p>If yes then and example will really help.</p>
  
  <p>-Thanks</p>