2.Mysql数据库——向表内插入数据

旧城等待， 2023-06-19 02:55 13阅读 0赞

## Mysql数据库——向表内插入数据 ##

### 一、插入元组 ###

**数据库:own ->>表:fruit**

**->>> 数据插入语法:**

insert into 表名(列名1, 列名2, 列名3,...)
    
    values(列值1,列值2,列值3,...)

*备注：列值需要与列名一一对应*

**示例一：(插入全部数据)**

#列名与值一一对应即可，顺序可以与表中的顺序不一致
    insert into fruit(id,name,price,num)
    values(1,"香蕉",3.11,10);

![20191204153839333.png][]

![2019120415385329.png][]

![20191204153908589.png][]

**示例二：(插入部分数据)【根据自己需要的列选择，最常用】**

insert into fruit(name,num)
    values("苹果",10);

![20191204154411269.png][]

![20191204154439731.png][]

**示例三：(省略列名插入数据)【默认为所有列插入数据】**

#此时必须为4个值，与列一一对应
    insert into fruit
    values(3,"橘子",null,20);

![20191204155249472.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw_size_16_color_FFFFFF_t_70][]

注意点：

(1)非空列必须给数据

(2)自增列可不插入数据

### 二、插入子查询结果 ###

**->>> 数据插入语法:**

insert into 表名
    子查询结果

**示例一：**

insert into fruit
    select * from fruits where price>10;

![20191204160600233.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw_size_16_color_FFFFFF_t_70 1][]

**示例二：**

insert into fruit(name,num)
    select name, num from fruits;

![20191204161102561.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw_size_16_color_FFFFFF_t_70 2][]

[20191204153839333.png]: https://img-blog.csdnimg.cn/20191204153839333.png
[2019120415385329.png]: https://img-blog.csdnimg.cn/2019120415385329.png
[20191204153908589.png]: https://img-blog.csdnimg.cn/20191204153908589.png
[20191204154411269.png]: https://img-blog.csdnimg.cn/20191204154411269.png
[20191204154439731.png]: https://img-blog.csdnimg.cn/20191204154439731.png
[20191204155249472.png]: https://img-blog.csdnimg.cn/20191204155249472.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191204155300515.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw==,size_16,color_FFFFFF,t_70
[20191204160600233.png]: https://img-blog.csdnimg.cn/20191204160600233.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191204160639118.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw==,size_16,color_FFFFFF,t_70
[20191204161102561.png]: https://img-blog.csdnimg.cn/20191204161102561.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191204161157532.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjgzMDY5Nw==,size_16,color_FFFFFF,t_70