创建数据表:Mysql> use simonwangDatabase changedmysql> show tables;Empty set (0.00 sec)mysql> create
创建数据表:
Mysql> use simonwang
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> create table t1 (`id` int(4), `name` char(40));
Query OK, 0 rows affected (0.01 sec)
插入数据:
mysql> insert into studytable values(1,'test');
Query OK, 1 row affected (0.00 sec)
mysql> select * from studytable;
+------+------+
| id | name |
+------+------+
| 1 | test |
+------+------+
1 row in set (0.00 sec)
修改数据:
mysql> update studytable set name='updatetest' where id='1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from studytable;
+------+------------+
| id | name |
+------+------------+
| 1 | updatetest |
+------+------------+
1 row in set (0.00 sec)
清空数据表:
mysql> truncate table studytable;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from studytable;
Empty set (0.00 sec)
删除数据表:
mysql> drop table studytable;
Query OK, 0 rows affected (0.00 sec)
删除数据库:
mysql> drop database simonwang;
Query OK, 0 rows affected (0.01 sec)
--结束END--
本文标题: mysql增删改查
本文链接: https://www.lsjlt.com/news/37142.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-28
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0