One of the MySQL review

DROP DATABASE mysql_shiyan;。

CD /home/shiyanlou/desktop

Git clone https://github.com/shiyanlou/SQL4

#打开 MySQL Service

sudo service MySQL start

Description: The sudo command is used to execute commands in other identities, and the default identity is root.

#使用 Root User login

Mysql-u Root

Load the data in the experiment:

Source /home/shiyan/desktop/sql4/mysql-04-01.sql

Connection query:

SELECT ID,name,people_num from employee, Department WHERE EMPLOYEE.IN_DPT = Department.dpt_name ORDER by ID;

SELECT ID,name,people_num from employee JOIN Department on EMPLOYEE.IN_DPT = Department.dpt_ Name ORDER by ID;

One of the MySQL review