Shulou(Shulou.com)05/31 Report--

This article will explain in detail about the introduction of Mysql installation test database employees, Xiaobian think it is very practical, so share it for everyone to make a reference, I hope you can gain something after reading this article.

More Free Learning Recommendations:

Mysql installation test database employees

1. Download the employees test database file

2. Ubuntu environment installation

3. Windows installation

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. input at terminal

mysql -uroot -p123456 -t

As shown below, obviously an error was reported, obviously an error occurred on line 38 of employees.sql:

Solution: Open employees.sql and modify storage_engine to default_storage_engine.38 and 44 lines need to be modified, as shown in the following figure:

Save employees.sql after modification, re-enter command

mysql -uroot -p123456 -t

The installation of employees test data class is completed, and the result symbol is shown in the following figure, or execute sql statement to query the information of the database table.

See blog from casainurbania

3. Windows installation

1.win +r Enter cmd to enter the command line

2. Find the file location of the employees you downloaded

Copy folder path, command-line input

cd C:\Program Files\MySQL\employees_db# cd Copy the path of the folder mysql -uroot-p123456-t < employees.sql#-p followed by your own linked database password, modify #according to the actual situation (note that you must open the terminal under the downloaded folder)

Installation completed, verification results, if encountered mysql is not an internal command can refer to solve mysql is not an internal command problem

About "Introduction Mysql installation test database employees" This article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.