title: Not able to insert data in a table having foreign key using mysql
body: <p>i have made 2 tables
  2nd table consists of foreign key which references primary key of first table 
  2nd table consists of 3 fields id(primary key),order no,fid
  i am using the following command</p>
  
  <p>insert into table2 (order no,fid)
  values(1,(select id from table1 where name='abc');</p>
  
  <p>error in sql syntax<code>enter code here</code></p>