• notice
  • Congratulations on the launch of the Sought Tech site

Mysql Database SQL Script Import

1. Enter the mysql command line window

mysql -uroot -p ***** *

2156747-20220928153938652-334180212.png

2. Display all databases

show databases;

2156747-20220928154043787-1942133480.png

3. Select the database

use database name

4. Display all tables of the specified database

show  tables ;

5. Import the specified sql script data

SOURCE   The absolute path of the script to be imported
Example : SOURCE  /songwp/ project /java/ workreal/workereal0410.sql


Tags

Technical otaku

Sought technology together

Related Topic

0 Comments

Leave a Reply

+