Shulou(Shulou.com)05/31 Report--

Editor to share with you how to find the advantages of MySQL, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Step 1-install MySQL

Go to http://dev.mysql.com/downloads/ to download the server, MySQLGUI tool, and MySQLODBC driver. The servers you can choose are: 5.0, minute 5.1 or 6.0. Then install them.

Considerations during installation:

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

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

MySQL installs the default username/login=root and server=localhost.

MySQL provides a choice of storage engine / table types-- mainly MySAM and InnoDb. The latter looks more like Access, which has transactions and foreign keys, so we use this approach in this article.

There are user and security options. Don't forget to record all the passwords.

Also need to install BullzipAccesstoMySQL and Dreamcoder for later use.

Step 2-move the table from access to MySQL

Use Bullzip to transfer background tables to MySQL, or open your database and export your data through ODBC.

Matters to be noted:

MySQL does not recognize the functions that Access defaults to fields (such as the Now () and Date () functions in the Date/Time field): they may be deleted or the table rejected. It is recommended that you delete them before transferring / exporting.

The autonumber field of Access is inconsistent with the auto_increment field of MySQL. Bullzip converts when it is transferred, while ODBC does not.

The Access data type is converted to a similar MySQL data type. However, the scope is larger in MySQL, and you may want to change them later.

"oleobject" in Access becomes "blob" in MySQL. Because of an OLE server problem, we changed blobs to longtext.

Step 3-change the MySQL table (field)

Open the Dreamcoder or MySQL Manager (a GUI tool). If you are familiar with SQLServer, think of these as Enterprise or SQLservermanagementstudioexpress interfaces.

Connect to the transferred / exported database.

The above is all the contents of the article "how to find the advantages of MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.