In-depth analysis: Find the advantages of MySQL

FromMySQLThe steps to find the advantages of the MySQL database are described in the following three aspects: Install the table, migrate the table from Access to MySQL, and change the MySQL table, I believe that you will have a new understanding of MySQL databases through the following learning.

Step 1-install MySQL

Download this server, MySQL GUI tool, and MySQL ODBC driver from http://dev.mysql.com/downloads. You can select 5.0, 5.1, or 6.0 servers. Then install them.

Precautions during installation:

Your Firewall should be set to allow connections through port 3306.

Run MySQL as a service (you can select the command line mode ).

MySQL installation default username/login = root and server = localhost.

MySQL provides the storage engine/table type options-MySAM and InnoDb. The latter looks more like Access, which has transactions and Foreign keys, so we use this method in this article.

Has user and security options. Do not forget to record all passwords.

Install Bullzip Access to MySQL and Dreamcoder for later use.

Step 2 -- move the table from Access to MySQL

Use Bullzip to migrate the background data table to MySQL, or open your database and export your data through ODBC.

Note:

MySQL does not recognize the functions that Access uses by default for fields (such as the Now () and Date () functions in the Date/Time fields): they may be deleted or the table may be rejected. We recommend that you delete them before transferring/exporting them.

The autonumber field of Access is inconsistent with the auto_increment field of MySQL. Bullzip will be converted during the transfer, but ODBC will not.

The Access data type is converted to a similar MySQL Data Type. However, MySQL has a wider range and you may want to change them later.

The "ole object" of Access is changed to "blob" in MySQL ". Because of an OLE server problem, we changed blobs to longtext.

Step 3: Change the MySQL table (field)

Open Dreamcoder or MySQL Manager (a GUI tool ). If you are familiar with SQL Server, consider these as Enterprise or SQL server management studio express interfaces.

Connect to the database for transfer/export.