More related free learning recommendations: mysql tutorial(Video)
Mysql installation test database employees
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 <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<br><img src="https://img.php.cn/upload/article/000/000/052/2e020391dc4c3640d93196cf543e4d77-2.png" alt="Introduction to Mysql installation test database employees"></p><p>Refer to the blog from casainurbania</p><p><strong>3. Installation under windows</strong></p><p>1.win r and enter cmd to enter the command line<br> 2.Find the downloaded file Employees' file location <br><img src="https://img.php.cn/upload/article/000/000/052/8ede5279b0dc711d59b89d7258a90196-3.png" alt="Introduction to Mysql installation test database employees"> Copy the folder path and enter </p><pre class="brush:php;toolbar:false">cd C:\Program Files\MySQL\employees_db# cd 复制文件夹的路径 mysql -uroot -p123456 -t <p><img src="https://img.php.cn/upload/article/000/000/052/8ede5279b0dc711d59b89d7258a90196-4.png" alt="Introduction to Mysql installation test database employees"><br> 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<br><img src="https://img.php.cn/upload/article/000/000/052/b5b5fc26d7e0f559425baaf102c5938e-5.png" alt="Introduction to Mysql installation test database employees"></p><blockquote><p>#Related learning recommendations:<a href="https://www.php.cn/course/list/51.html" target="_blank">mysql database</a></p></blockquote>
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!