Collections:
Loading Data Files with "mysqlimport" Command in MySQL
How To Load Data Files into Tables with "mysqlimport" in MySQL?
✍: FYIcenter.com
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\bin >type \temp\links.tab dev.fyicenter.com www.mysql.com >mysqlimport -u root test \temp\links.tab test.links: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0 >mysql -u root -e "SELECT * FROM links" test +-------------------+ | name | +-------------------+ | dba.fyicenter.com | | dev.fyicenter.com | | www.mysql.com | +-------------------+
⇒ Command-Line End User Interface 'mysql'
⇐ What Is "mysqlimport" Command in MySQL
2018-04-28, 1595🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...