How to convert access to mysql_MySQL-mysql tutorial

Source: Internet
Author: User
Tags mysql tutorial
Access can only use this same life-saving feature in windows, which makes me feel terrible and hard to switch access to mysql. However, I have found many articles on the internet and have not directly converted it. I heard that odbc can be used for conversion, so I tried it. Install mysql and myodbc first, create an empty mysql database, add this database to odbc management, and specify Access

Access can only use this same life-saving feature in windows, which makes me feel terrible and hard to switch access to mysql. However, I have found many articles on the internet and have not directly converted it. I heard that odbc can be used for conversion, so I tried it.

Install mysql and myodbc first, create an empty mysql database, add the database to odbc management, and specify the name.

Open the database with access2000, select Export, select odbc, select the machine data source, select the mysql odbc data source you just created, and then export it.

Only one table can be inverted at a time.

..........

Finally, is it successful now?

Change the data source in the program to the mysql odbc, and find errors everywhere. The original mysql table is case sensitive. after the program is changed, it feels good to run and the speed is fine.

No. why is it wrong? how is this ID empty ???

In the past, the imported database does not support the auto-increment function.

Continue to the mysql Directory. run mysqldump in bin to output all the structures and data to the file my. SQL, edit my. SQL, and modify all the CREATE TABLE statements,
ID int not null auto_increment, primary key (ID), so the ID is equivalent to the automatic number data type in access. run mysql in mysql/bin and drop the original database, next, let's look at the modified my. all SQL data is restored. this is all done. The program is much faster than usual, especially in the forum.

Note: this operation is performed in windows 2000.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.