Mysql修改表中单个数据的示例:语法:update 表名 set 字段名=‘新内容’+ where条件示例代码:mysql> select* from&
Mysql修改表中单个数据的示例:
语法:
update 表名 set 字段名=‘新内容’+ where条件
示例代码:
mysql> select* from `runoob_tbl`;+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2018-08-15 |
| 2 | 学习 Mysql | 菜鸟教程 | 2018-08-15 |
| 3 | JAVA 教程 | RUNOOB.COM | 2018-08-15 |
+-----------+--------------+---------------+-----------------+
3 rows in set (0.04 sec)
mysql> update `runoob_tbl` set `submission_date`='2016-05-06' where `runoob_id`=3;
Query OK, 1 row affected (0.16 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select* from `runoob_tbl`;
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 php | 菜鸟教程 | 2018-08-15 |
| 2 | 学习 MySQL | 菜鸟教程 | 2018-08-15 |
| 3 | JAVA 教程 | RUNOOB.COM | 2016-05-06 |
+-----------+--------------+---------------+-----------------+
3 rows in set (0.04 sec)
--结束END--
本文标题: mysql怎么修改表的单个数据
本文链接: https://www.lsjlt.com/news/112110.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-11
2024-05-11
2024-05-11
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0