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