How To Load Data Files Into Tables With "mysqlimport"

How To Load Data Files Into Tables With "mysqlimport"


  • 20 Feb, 2012

    If you want to load a data file directly into a table, you need to prepare the data file as one line per data row, and use tab character as the column delimiter. The data file name should match the target table name. The following is a good tutorial exercise on using "mysqlimport":>cd mysql in>type emplinks.tabwww.GlobalGuideLine.comwww.mysql.com>mysqlimport -u root test emplinks.tabtest.links: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0>mysql -u root -e "SELECT * FROM links" test+-------------------------+| name |+-------------------------+| www.GlobalGuideLine.com || www.GlobalGuideLine.com || www.mysql.com |+-------------------------+

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.