MySQL use at the command line

1. Installation of MySQL under Mac: http://my.oschina.net/joanfen/blog/171109

2. Before using MySQL, make sure that the MySQL service in "System number Setup" is turned on

3. Open "Terminal", enter "Mysql-uroot-p" and enter the password you defined at the time of installation.

4. Basic Operation statement

(1) Show databases; (Show all databases )

(2) Use Pkusz; (using a database, Pkusz is one of my database names)

(3) Show tables;

5. Export the SQL file

(1) Use "terminal" to enter the path you want the file to export, such as Desktop

(2) then enter "Mysqldump-uroot-p Pkusz > Pkusz.sql" and enter the database password finally

(3) A file with the name of SQL suffix will be exported

6. Import SQL file

(1) First use "terminal" to enter the database

(2) Create a database with the same name as the SQL file

(3) Mysql>source pkusz.sql; Can