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

Source: Internet
Author: User
Tags mysql gui

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
  1. First step: Open Navicat to create a connection to the database.

  2. 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.

  3.  

     

     

     

     

    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

  4.  

     

     

     

     

    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

  5.  

     

     

     

    Fifth step: type Select Excel file

  6.  

     

     

     

     

     

     

     

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


  7. 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

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.