"MySQL must know" learn 2018/7/24--Huan

Resolve the issue in 1:mysql Import the SQL file.

Step 1:show databases; #看看我有什么数据库

Step 2:use hh; #我要用hh这个数据库, return to database changed instructions open successfully.

Step 3:show tables; #看看hh这个数据库里面有那些表

Step 4:source F:/bzbh/mysql_scripts/create.sql; # (another source f:/bzbh/mysql_scripts/populate.sql) the location of the script is F:\bzbh\mysql_scripts

Step 4:show tables; #再次看看hh数据库里面有那些表 to see if the two scripts you just imported were successful. Note: The two script that you just imported, not two tables, so the table name is not the same as the name of the script. You can see that the table has been added a few, is the script inside the table again.

"MySQL must know" learn 2018/7/24--Huan