"MySQL note" Excel data import MySQL database implementation method--navicat

Many companies, especially a few years of the company, the financial Business Department of various forms are excel to do the table, along with the development of the Internet all kinds of business processes are electronic process, and then in the vast number of documents to find a year of the month report is a rather boring thing, So all in a way to direct the previous data into the modern intelligent Office program, where many novice programmers will be a bit scratching their heads, below to introduce my small experience, I hope to provide convenience for everyone! Tools/Materials

• Let's start by explaining why I'm using Navicat, the first reason, because it's a good MySQL GUI tool, and more importantly, it can import some external data sources into the MySQL database. Because my data source is Excel data, I want to use Navicat to import it into MySQL.

Method/Step

2. First step: Open Navicat to create a connection to the database.

4. The second step: Enter the connection address, Local is localhost, database name, the general default is Root,mysql port number default is 3306, password is filled, no left blank.

6.  

    

    

    

    

   P style= "padding:0px;" > 

    

    

   step three: the previous success, You can see the connection icon named localhost. Double click to open it, the general MySQL default has two databases, respectively, MySQL and test. These two libraries do not care, if you want to import the library, then must be able to see your library, double-click Open your library, I here is a new library temporarily named demo, the name can be arbitrarily taken, here need to pay attention to the character set, the programmer is generally called encoding format, If you have Chinese in Excel, it's best to choose gb2312

8.  

    

    

    

    

   P style= "padding:0px;" > Fourth step: Click the Import Wizard button at the top right of the Navicat form to go to the Import Wizard and follow the wizard step-by-step configuration

10.  

     

     

     

    Fifth step: type Select Excel file

12.  

     

     

     

     

     

     

     

    Sixth step: Select the exact location of the Excel file you want to import and a table in Excel, and configure the table structure

14. 
    

    Seventh Step: Click to start the import, to the original excel in the data can be simply imported into the database, to see the database demo, see if there is already your Excel table, the specific table structure must be set, this is not only for the import of the smooth, It is easier to make the data calls to this database later.

Precautions

• Note: If you have Chinese in Excel, the character set must be selected gb2312 Otherwise, garbled results in data cannot be viewed.
• Emphasis: When importing the table structure is best to design, so that the import is more conducive to the use of the library later.
  Source: http://jingyan.baidu.com/article/f7ff0bfc79d6512e26bb13a9.html

From for notes (Wiz)

"MySQL note" Excel data import MySQL database implementation method--navicat