MySQL Programming Question:
Download Job Interview Questions and Answers PDF
How To Load Data Files into Tables with "mysqlimport"?
Answer:
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 mysqlin
>type emplinks.tab
www.GlobalGuideLine.com
www.mysql.com
>mysqlimport -u root test emplinks.tab
test.links: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0
>mysql -u root -e "SELECT * FROM links" test
<pre>+-------------------------+
| name |
+-------------------------+
| www.GlobalGuideLine.com |
| www.GlobalGuideLine.com |
| www.mysql.com |
+-------------------------+</pre>
>cd mysqlin
>type emplinks.tab
www.GlobalGuideLine.com
www.mysql.com
>mysqlimport -u root test emplinks.tab
test.links: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0
>mysql -u root -e "SELECT * FROM links" test
<pre>+-------------------------+
| name |
+-------------------------+
| www.GlobalGuideLine.com |
| www.GlobalGuideLine.com |
| www.mysql.com |
+-------------------------+</pre>
Download MySQL Programming Interview Questions And Answers
PDF
Previous Question | Next Question |
What Is "mysqlimport"? | What Is the Command Line End User Interface - mysql? |