MYSQL自带客户端test

-- 登录MySQL
mysql -h localhost -uroot -p
Enter password: ******
mysql> select "hello world!!!";
+----------------+
| hello world!!! |
+----------------+
| hello world!!! |
+----------------+
1 row in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| bishe              |
| db_order_20200417  |
| information_schema |
| mysql              |
| online_sale        |
| performance_schema |
| school             |
| sony_xiaozao       |
| sys                |
| test.csv           |
| xiaozao            |
| xiaozao_课程sql    |
| 电商销售           |
+--------------------+
13 rows in set (0.01 sec)

mysql> create database demo;
Query OK, 1 row affected (0.02 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| bishe              |
| db_order_20200417  |
| demo               |
| information_schema |
| mysql              |
| online_sale        |
| performance_schema |
| school             |
| sony_xiaozao       |
| sys                |
| test.csv           |
| xiaozao            |
| xiaozao_课程sql    |
| 电商销售           |
+--------------------+
14 rows in set (0.00 sec)

mysql> use demo;
Database changed
mysql> create table demo_20200418(id int,name varchar(100),age int,sex int);
Query OK, 0 rows affected (0.03 sec)

mysql> insert into demo_20200418 values(1,'nathan',19,1);
Query OK, 1 row affected (0.01 sec)

mysql> insert into demo_20200418 values (2,'Jack',18,1);
Query OK, 1 row affected (0.01 sec)

mysql> insert into demo_20200418 values (3,'lucy',20,2);
Query OK, 1 row affected (0.00 sec)

mysql> insert into demo_20200418 values (4,'limeng',19,1);
Query OK, 1 row affected (0.00 sec)

mysql> insert into demo_20200418 values (5,'king',18,1);
Query OK, 1 row affected (0.01 sec)

mysql> insert into demo_20200418 values (6,'sandy',21,2);
Query OK, 1 row affected (0.00 sec)

mysql> insert into demo_20200418 values (7,'wu',17,2);
Query OK, 1 row affected (0.00 sec)

mysql> select * from demo_20200418;
+------+--------+------+------+
| id   | name   | age  | sex  |
+------+--------+------+------+
|    1 | nathan |   19 |    1 |
|    2 | Jack   |   18 |    1 |
|    3 | lucy   |   20 |    2 |
|    4 | limeng |   19 |    1 |
|    5 | king   |   18 |    1 |
|    6 | sandy  |   21 |    2 |
|    7 | wu     |   17 |    2 |
+------+--------+------+------+
7 rows in set (0.00 sec)

-- 补充：
/*
注意两者使用上的区别：
delete from t_student；删除表格t_student中的数据
drop table t_student；删除表格t_student
*/

-- 删表操作：
mysql> drop table demo_20200418;
Query OK, 0 rows affected (0.02 sec)

mysql> select * from demo_20200418;
ERROR 1146 (42S02): Table 'demo.demo_20200418' doesn't exist

-- 只删除数据：
mysql> create table demo_20200418(id int,name varchar(100),age int,sex int);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into demo_20200418 values (2,'Jack',18,1);
Query OK, 1 row affected (0.01 sec)

mysql> insert into demo_20200418 values (4,'limeng',19,1);
Query OK, 1 row affected (0.00 sec)

mysql> select * from demo_20200418;
+------+--------+------+------+
| id   | name   | age  | sex  |
+------+--------+------+------+
|    2 | Jack   |   18 |    1 |
|    4 | limeng |   19 |    1 |
+------+--------+------+------+
2 rows in set (0.00 sec)

mysql> delete from demo_20200418;
Query OK, 2 rows affected (0.00 sec)

mysql> select * from demo_20200418;
Empty set (0.00 sec)

-- 删掉练习使用的临时的数据库
mysql> drop database demo;
Query OK, 1 row affected (0.04 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| bishe              |
| db_order_20200417  |
| information_schema |
| mysql              |
| online_sale        |
| performance_schema |
| school             |
| sony_xiaozao       |
| sys                |
| test.csv           |
| xiaozao            |
| xiaozao_课程sql    |
| 电商销售           |
+--------------------+
13 rows in set (0.00 sec)

1.3.2 MySQL练习
关键代码和数据附录（供练习使用）

# 创建一个数据库demo
create database demo;
#进入数据库demo
use demo;
#在demo数据数据库中创建
create table demo (id int,namevarchar(100),age int,sexint);
# 往demo中插入数据
insert into demo values (1,'nathan',19,1);
insert into demo values (2,'Jack',18,1);
insert into demo values (3,'lucy',20,2);
insert into demo values (4,'limeng',19,1);
insert into demo values (5,'king',18,1);
insert into demo values (6,'sandy',21,2);
insert into demo values (7,'wu',17,2);

-- shengming:
/*
在创建表，必须先创建库，如果创建好数据库；
就要先指定数据库，然后再使用创建表；
*/