My MySQL database learning Summary

1. Installation and Environment Settings
I installed MySQL5.0 + MySQL-Front3.2 + mysql-connector-java-3.1.14
The default setting is used.
I am mainly used to support JDBC (put the mysql-connector-java-3.1.14-bin.jar under the JDK directory \ jre \ lib \ ext)

2. Test
Console or MySQL Command Line Client (I prefer the latter ).
Create a table and test the Four Kings: add, delete, query, and modify.
Do not use a visualization tool first. exercise for a period of time under the command line.

3. Chinese Solution
Log on to the console using mysql -- default-character-set = gbk-u root-p
Use the charset gbk Command in MySQL Command Line Client;

4. I like MySQL
I Love Open Source