当前位置：网站首页>How will Import SQL file into MySQL

How will Import SQL file into MySQL

2022-07-22 00:48:00 【He Qiang Bangbang】

First of all 、 Get into mysql database ： stay cmd Input in mysql -u root -p Then input password
Insert picture description here
second 、 Create a new database （ It can be the same as the name of the library you want to import ）

create database test_db;

Insert picture description here
Third 、 Enter the established empty database test_db:use test_db;

Insert picture description here
Fourth 、source + .sql File path ：source C:\Users\Administrator\Desktop\Msq note \test_db.sql;
The fifth 、 View the table of the library , It was found that the import was successful show tables;