简单的MySQL查询问题(Simple MySQL query question)
我该怎么做(方括号中的部分):
$name = 'Bob'; mysql_query("INSERT INTO table(field1,field2) [ select value of field1 from another table ], '$name'");How would I do this (the part in square brackets):
$name = 'Bob'; mysql_query("INSERT INTO table(field1,field2) [ select value of field1 from another table ], '$name'");最满意答案
它的SQL部分可能如下所示:
INSERT INTO table1 (field1, field2) SELECT field1, 'Bob' FROM table2 WHERE ...在PHP中动态构建它是一个简单的练习我留给读者:)
The SQL part of it might look like this:
INSERT INTO table1 (field1, field2) SELECT field1, 'Bob' FROM table2 WHERE ...Dynamically constructing that in PHP is a simple exercise I leave up to the reader :)
更多推荐
发布评论