Mysql 成长之路（二）创建数据库与创建表

启动Mysql

命令行开启Mysql服务并登陆Mysql：

mysql.server start
mysql -uroot -p你的密码

新建数据库

查看现有数据库并创建名为learn_mysql的数据库：

第1行 ——查看现有数据库

第12行 ——创建learn_mysql数据库

第15行 ——查看是否创建成功

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> create database learn_mysql;
Query OK, 1 row affected (0.06 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| learn_mysql        |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

新建一张表

进入新建的learn_mysql数据库

mysql> use learn_mysql;
Database changed
mysql> show tables;
Empty set (0.01 sec)

创建名为simple_account的表：

建表sql语句为：

create table simple_account
(
	id			int				not null auto_increment,
	name		char(20)		not null,
	sex			char(10)		not null,
	age			int 			not null,
	money       decimal(10, 2)  not null,
	primary key (id)
) engine=InnoDB, charset=utf8;

建表结果：

mysql> show tables;
+-----------------------+
| Tables_in_learn_mysql |
+-----------------------+
| simple_account        |
+-----------------------+
1 row in set (0.00 sec)

查看simple_account表的描述：

mysql> describe simple_account;
+-------+---------------+------+-----+---------+----------------+
| Field | Type          | Null | Key | Default | Extra          |
+-------+---------------+------+-----+---------+----------------+
| id    | int(11)       | NO   | PRI | NULL    | auto_increment |
| name  | char(20)      | NO   |     | NULL    |                |
| sex   | char(10)      | NO   |     | NULL    |                |
| age   | int(11)       | NO   |     | NULL    |                |
| money | decimal(10,2) | NO   |     | NULL    |                |
+-------+---------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

向表中插入数据

• 没有分号结尾的情况下可以回车换行，终止当前命令键入\c。
• 如果没有指定插入的列，则values必须按顺序包含所有的列（前三条）。
• 表中设置为auto_increment的列为自增。

mysql> insert into simple_account
    -> values(1, "Tom", "man", "20", 4539.02);
Query OK, 1 row affected (0.08 sec)

mysql> insert into simple_account values(2, "Jack", "man", "19", 2109.50);
Query OK, 1 row affected (0.07 sec)

mysql> insert into simple_account values(3, "原氏", "man", "17", 666.66);
Query OK, 1 row affected (0.08 sec)

mysql> insert into simple_account (name, sex, age, money) values( "半藏", "man", "22", 1666.66);
Query OK, 1 row affected (0.06 sec)

mysql> insert into simple_account (name, sex, age, money) values( "天使", "woman", "23", 9700);
Query OK, 1 row affected (0.12 sec)

mysql> insert into simple_account (name, sex, age, money) values( "莫伊拉", "woman", "30", 5980.02);
Query OK, 1 row affected (0.17 sec)

查询当前表结果

mysql> select * from simple_account;
+----+-----------+-------+-----+---------+
| id | name      | sex   | age | money   |
+----+-----------+-------+-----+---------+
|  1 | Tom       | man   |  20 | 4539.02 |
|  2 | Jack      | man   |  19 | 2109.50 |
|  3 | 原氏      | man   |  17 |  666.66 |
|  4 | 半藏      | man   |  22 | 1666.66 |
|  5 | 天使      | woman |  23 | 9700.00 |
|  6 | 莫伊拉    | woman |  30 | 5980.02 |
+----+-----------+-------+-----+---------+
6 rows in set (0.00 sec)

退出Mysql并关闭服务

mysql> quit
Bye

mysql.server stop