Introduction to Mysql installation test database employees

More related free learning recommendations: mysql tutorial(Video)

Mysql installation test database employees

• 1. Download the employees test database file
• 2. Install in Ubuntu environment
• 3. Install under windows

1. Download the employees test database file

Official website download: employees official website download

2. Ubuntu environment installation

1. Open the terminal in the downloaded test database folder directory
2. Enter

mysql -uroot -p123456 -t < employees.sql#-p后跟的是自己的链接数据库密码，根据实际情况修改#(注意一定要在下载好的文件夹下打开终端)

in the terminal as shown below. Obviously an error is reported. It is obviously an error in line 38 of employees.sql:
Solution: Open employees.sqlModify storage_engine to default_storage_engine,Both rows 38 and 44 must be modified, as shown below:
Modify After completion, save employees.sql and re-enter the command

mysql -uroot -p123456 -t < employees.sql#-p后跟的是自己的链接数据库密码，根据实际情况修改#(注意一定要在下载好的文件夹下打开终端)

to complete the installation of the employees test data course. The result mark is as shown below, or execute the sql statement to query the information of the database table

Refer to the blog from casainurbania

3. Installation under windows

1.win r and enter cmd to enter the command line
2.Find the downloaded file Employees' file location
Copy the folder path and enter

cd C:\Program Files\MySQL\employees_db# cd 复制文件夹的路径 mysql -uroot -p123456 -t < employees.sql#-p后跟的是自己的链接数据库密码，根据实际情况修改#(注意一定要在下载好的文件夹下打开终端)

on the command line. The installation is complete and the results are verified. If you encounter the mysql is not internal command, you can refer to Solve the problem that mysql is not internal. Command problem

#Related learning recommendations:mysql database

The above is the detailed content of Introduction to Mysql installation test database employees. For more information, please follow other related articles on the PHP Chinese website!