我正在尝试进行查询,将表单中的多个值插入到表中的一行中.
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')";我发现的一切都告诉我这应该可以使用 PHP 和 MySQl 数据库工作.如果我在语法上做错了什么或我的问题出在哪里,有什么想法吗?谢谢
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
推荐答案我们可能需要更多信息,但有以下几点:
We might need more information however a couple of things:
- 如果您在 unix 中使用 mysql,则基于系统表区分大小写.
第二,您应该在列名上使用 ` 而不是 ' 吗?(我会说它们都是必需的),例如:
- 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`) 甚至更好 INSERT INTO tbl_Answer(Answer)
INSERT INTO tbl_Answer(`Answer`) or even better INSERT INTO tbl_Answer(Answer)
更多推荐
单个插入查询以在一列中插入多行
发布评论