Practice: import an ACCESS database to a mysql database

As a programmer, it is often necessary to import and export data between different databases to save data entry time. Next I will share with you how to import data from the ACCESS database to the mysql database.

First of all, I would like to explain some ideas. There are many ways to import mysql, but access is not included. There are many methods to import mysql in CSV format on the Internet, but the operation is inconvenient, errors often occur and cannot be imported. SQL statement import is the simplest. Is there a way to convert an access database into an SQL statement. The following section describes how to easily convert an access database into an "insert into table" SQL statement using the Export db2mysql.exe tool. After an SQL statement is created, copy and paste the statement to phpmyadmin and run it.

The following are software operations.

 

 

 

 

 

Is it very simple, but it should be noted that the data imported through DB2mysql does not support Chinese characters and Chinese characters will become? . I am thinking about how to solve this problem. If the majority of readers have good convenience, please leave a message! This article is the beginning of webmaster's website. For reposted, please keep www.678baidu.com