启动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