title: insert data from select query results and adding a new column
body: <p>I already read the similar question on the website. but I still not able to find out the problem. I would like to copy data from table "main" to table "metro" and add one more column. but the statment havn't run and no error prompting.</p>
  
  <pre><code>$s_id=crypt($myid);
  $result = mysqli_query($link, "INSERT INTO users (username, password, s_id, email, dob) VALUES ('$myid', '$mypw', '$s_id', '$email', STR_TO_DATE('$dob', '%d/%m/%Y'));");
  $result = mysqli_query($link, "SELECT user_id FROM users WHERE username='$myid'");
  $row = mysqli_fetch_array($result,MYSQLI_BOTH);
  $user_id=$row["user_id"];
  //below is the statment which can't be perform.
  $result = mysqli_query($link, "INSERT INTO metro (ID, Row, Column, Caption, link, Ico, Size, Color, user_id) SELECT ID, Row, Column, Caption, link, Ico, Size, Color, '$user_id' FROM main");
  </code></pre>
  
  <p>The table "main" only have the field
  <code>(ID,Row,Column,Caption,link,Ico,Size,Color)</code><br>
  The table "metro" only have the above field and field(user_id)
  I tried to run the statment<br>
  <code>INSERT INTO...</code><br>
  in phpmyadmin
  the error message show "#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near<br>
  <code>'Column, Caption, link, Ico, Size, Color, user_id) SELECT ID, Row, Column, Captio' at line 1"</code><br>
   I wonder if the field name <code>Row</code> and <code>Column</code> is keyword. The color of these two word become red.</p>