单个插入查询以在一列中插入多行

Question

I am trying to make a query that will insert multiple values from my form into a single row in my table.

 $q2="INSERT INTO tbl_Answer('Answer')VALUES ('$A1'),('$A2'),('$A3'),('$A4'),('$A5')";

Everything I have found tells me this should work using PHP with a MySQl database. Any ideas if I have done something wrong with the syntax or where my issue is? Thanks

Answer 1

We might need more information however a couple of things:

• If you are using mysql in unix based system tables are case sensitive.

• Second, should you use ` instead of ' on the name of your columns?(and i would say they are both innecesary) like:

  INSERT INTO tbl_Answer(`Answer`) or even better INSERT INTO tbl_Answer(Answer)