Home > Database > Mysql Tutorial > body text

How to import dbf format data into MySQL database?

黄舟
Release: 2017-08-07 14:38:19
Original
5611 people have browsed it

Importing data in dbf format from mysql database can be done in a few simple steps, and you don’t have to worry about it anymore.

How to import dbf format data into MySQL database?


##1. Open navicat for mysql software, Select the database into which you want to import data, click the Import Wizard button, and the Import Data dialog box will pop up.

How to import dbf format data into MySQL database?


##2. Select the dbase file (*. dbf), click Next

How to import dbf format data into MySQL database?


#3. Select the dbf format data to be imported. What needs to be noted here is that the encoding must be the same as the dbf file, otherwise the Chinese will be garbled.

How to import dbf format data into MySQL database?


##4. Select the target table. You can select an existing table or enter a new table name. Here we create a new test table

How to import dbf format data into MySQL database?

##5. This You can modify the properties of the table in one step. Click the arrow in the picture to set the primary key and set the field size.

How to import dbf format data into MySQL database?

#6. Next select the first one , add records to the target table

How to import dbf format data into MySQL database?

##7. Just click Start. When Finished Successfully appears, the data has been successfully imported.


##NoteHow to import dbf format data into MySQL database?The database character encoding must correspond

The above is the detailed content of How to import dbf format data into MySQL database?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template