一个查询插入多行多列

本文介绍了一个查询插入多行多列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

假设我要插入这些数据:

Let's say I want to insert this data:

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

Leave the columns you don't wanto to fill with null

INSERT INTO mytable(`People`, `Places`, Things, Ideas) VALUES ('40', '15', null, null),(null, null, 100, 20)