创建数据表:
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)