一起学mysql 07.mysql 更新数据

最新推荐文章于 2024-09-11 10:18:51 发布

隔壁小翔

最新推荐文章于 2024-09-11 10:18:51 发布

阅读量102

点赞数

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/tangwei0928/article/details/98437709

版权

mysql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

mysql 更新数据

mysql> select * from product where id=1001;
+------+-----------+--------------+--------------+--------------------+
| id   | name      | function     | company      | address            |
+------+-----------+--------------+--------------+--------------------+
| 1001 | ABC药物   | 治疗感冒     | ABC制药厂    | 北京市昌平区       |
+------+-----------+--------------+--------------+--------------------+
1 row in set (0.12 sec)

mysql> update product set name='AAA感冒药',address='北京市朝阳区' where id=1001;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from product where id=1001;
+------+--------------+--------------+--------------+--------------------+
| id   | name         | function     | company      | address            |
+------+--------------+--------------+--------------+--------------------+
| 1001 | AAA感冒药    | 治疗感冒     | ABC制药厂    | 北京市朝阳区       |
+------+--------------+--------------+--------------+--------------------+
1 row in set (0.00 sec)

mysql> select * from product where id>=1009 and id<=1011;
+------+------------+----------+--------------------+---------+
| id   | name       | function | company            | address |
+------+------------+----------+--------------------+---------+
| 1009 | 护发1号    | NULL     | 北京护发素厂       | NULL    |
| 1010 | 护发2号    | NULL     | 北京护发素厂       | NULL    |
| 1011 | 护发3号    | NULL     | 北京护发素厂       | NULL    |
+------+------------+----------+--------------------+---------+
3 rows in set (0.00 sec)

mysql> update product set function='护理头发',address='北京市昌平区' where id>=1009 and id<=1011;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> select * from product where id>=1009 and id<=1011;
+------+------------+--------------+--------------------+--------------------+
| id   | name       | function     | company            | address            |
+------+------------+--------------+--------------------+--------------------+
| 1009 | 护发1号    | 护理头发     | 北京护发素厂       | 北京市昌平区       |
| 1010 | 护发2号    | 护理头发     | 北京护发素厂       | 北京市昌平区       |
| 1011 | 护发3号    | 护理头发     | 北京护发素厂       | 北京市昌平区       |
+------+------------+--------------+--------------------+--------------------+
3 rows in set (0.00 sec)