MySQL Command line Operation review

in recent days has been doing a student status management system based on thinkphp RBAC, MySQL is a lot, although now MySQL excellent graphics software has been quite a lot, can significantly improve the speed of the operation of the database, Their most commonly used two is navicat and Mysql-front, of which the most satisfied is navicat, it is not only simple interface, the function of the latter more perfect some, in addition to support Mac Ox System, so I mostly use navicat. Feel a bit far, in fact, this article I want to say is that MySQL graphics software is to improve our efficiency, but still can not operate some of MySQL commands to forget, after all, not every machine has its own familiar with the MySQL graphics operating software.

Let's review some of the most basic MySQL operations:

1. Connect MySQL under cmd:

Successful Connection display content:

2. Show command to display the existing database

3. The create command creates the database:

To create the result:

4. Display the database name now selected

5. Create a table

6. View the structure of the table

7. Insert Table field, but error occurred

Solutions are:

When installing MySQL, the choice is utf8, so when inserting data, there is a coding error, the solution is to find the MySQL installation directory under the My.ini file, put the inside of the DEFAULT-CHARACTER-SET=GBK. Restart MySQL.

8. After modifying the My.ini, you have to restart MySQL.

9, then insert can be successful

10. Display the contents of the table

11, modify the structure of the table field

12. Backing Up the database

13. Backup Results

PS: Today first come here, casually spit groove school nets, upload a few pictures actually broken several nets!!!

MySQL Command line Operation review