版权声明:本文为博主原创文章,未经博主允许不得转载。
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- --显示所有的数据库
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | test |
- +--------------------+
- 3 rows in set (0.09 sec)
- --创建一个数据库test2
- mysql> create database test2;
- Query OK, 1 row affected (0.00 sec)
- --使用数据库test2
- mysql> use test2;
- Database changed
- --显示test2中的所有表
- mysql> show tables;
- Empty set (0.00 sec)
- --创建一个mytable表
- mysql> create table mytable (name varchar(20), sex char(1),
- -> birth date, birthaddr varchar(20));
- Query OK, 0 rows affected (0.14 sec)
- --显示数据库中的所有表
- mysql> show tables;
- +-----------------+
- | Tables_in_test2 |
- +-----------------+
- | mytable |
- +-----------------+
- 1 row in set (0.02 sec)
- --显示表结构
- mysql> describe mytable;
- +-----------+-------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------+-------------+------+-----+---------+-------+
- | name | varchar(20) | YES | | NULL | |
- | sex | char(1) | YES | | NULL | |
- | birth | date | YES | | NULL | |
- | birthaddr | varchar(20) | YES | | NULL | |
- +-----------+-------------+------+-----+---------+-------+
- 4 rows in set (0.07 sec)
- --查询表的所有字段
- mysql> select * from mytable;
- Empty set (0.00 sec)
- --向表中插入一条记录
- mysql> insert into mytable
- -> values(
- -> 'abc','f','1988-07-07','chian');
- Query OK, 1 row affected (0.08 sec)
- --查看表的记录
- mysql> select * from mytable;
- +------+------+------------+-----------+
- | name | sex | birth | birthaddr |
- +------+------+------------+-----------+
- | abc | f | 1988-07-07 | chian |
- +------+------+------------+-----------+
- 1 row in set (0.00 sec)