MySQL添加、更新、删除数据

谁借莪１个温暖的怀抱￠ 2022-11-17 14:51 164阅读 0赞

## MySQL添加、更新、删除数据 ##

1、查询数据

select \* from student;

![20210410163104709.png][]

2、添加数据

insert into student values(1,"张三","男",23,'1999-12-23','Java001','zhangsan@qq.com');

可以添加两条相同的数据，因为没有创建相应的约束constraint

insert into student values(1,"张三","男",23,'1999-12-23','Java001','zhangsan@qq.com');

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70][]

也可以添加指定位置的数据，其他位置默认为空

insert into student (sno,name,sex,classname)values (3,"王五","男","Java002");

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 1][]

日期有多种写法，具体可以看我上一篇博客[https://blog.csdn.net/qq\_48759664/article/details/115578645][https_blog.csdn.net_qq_48759664_article_details_115578645]

insert into student values(2,'李四','男',24,"1999/12/23","Java001","lisi@qq.com");

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 2][]

3、修改数据

update student set sex='女' where sno=2;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 3][]

4、删除数据

delete from student where email is null;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 4][]

删除数据库表student中所有数据

![20210410164342896.png][]

[20210410163104709.png]: /images/20221022/b554529de5304746942e4df403e667d7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70]: /images/20221022/14a61e81e8ca4a1cb95732da058252c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 1]: /images/20221022/f573782c6206446f976ef9b1906a69f5.png
[https_blog.csdn.net_qq_48759664_article_details_115578645]: https://blog.csdn.net/qq_48759664/article/details/115578645
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 2]: /images/20221022/82b2cf7897254a309c076d29b6472de3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 3]: /images/20221022/4373c7c8e8de4425b04741ee15a0cae3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 4]: /images/20221022/e307c5e967804d8f953cadfd5c993f4c.png
[20210410164342896.png]: /images/20221022/7b9f037d2a5d497ca053c6d172fbf317.png