一个查询以插入多行多列 [英] One query to insert multiple rows with multiple columns
本文介绍了一个查询以插入多行多列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
假设我要插入此数据:
Row 1: People = '40', Places = '15'
Row 2: People = '5', Places = '10'
我知道这是您执行上述操作的方式:
I understand that this is how you'd execute the above:
mysql_query("INSERT INTO mytable(`People`, `Places`)
VALUES ('40', '15'),('5', '10')");
但是,如果我想通过一个查询插入两个以上的列,该怎么办?如果要插入的数据是这样的:
But what if I wanted to insert into more than two columns with a single query? What if the data to be inserted was like this:
Row 1: People = '40', Places = '15'
Row 2: People = '5', Places = '10'
Row 3: Things = '140', Ideas = '20'
Row 4: People = '10', Things = '5', Ideas = '13'
我似乎在其他任何地方都找不到这样的问题.
I can't seem to find a question like this anywhere else.
推荐答案
用null
INSERT INTO mytable(`People`, `Places`, Things, Ideas)
VALUES ('40', '15', null, null),(null, null, 100, 20)
这篇关于一个查询以插入多行多列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文