MySQL entry-level learning records

1. MySQL version: MySql-5.1.42

2. Client: Heidisql (Official Website: http://www.heidisql.com /)

3. Install MySQL: MySQL installation graphic tutorial (http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html)

4. manually modify the configuration file:Modify the my. ini configuration file in the installation directory as needed

5. Basic MySQL operation commands

4.1 connect to the database:

Command server user database
Mysql-H localhost-u root-P Test

4.2 export table:

Command server User Password Database Export File
Mysqldump-H localhost-u root-Ptest -- opt test> D: \ test. SQL

4.3 import table
Mysql> source D: \ test. SQL

4.4 Export Database

Command server User Password Database Export File
Mysqldump-H localhost-u root-Ptest -- databases test> D: \ db1. SQL

4.5 import database

Command server user password
Mysql-H localhost-u root-Ptest <D: \ db1. SQL

6. Mysql Data Type Details: Http://blog.csdn.net/jiemushe1814/article/details/4716069

7. Summary: The power of MySQL lies in its flexible configuration. I used to use Microsoft products and suddenly found that MySQL could change the database settings by simply modifying the configuration file ~

MySQL has the following advantages over SQL:

Quick installation. After installation, the file is concise and there are no various binding software like MSSQL;

Clear configuration, flexible and powerful;

The client heidisql is very powerful and useful.