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, 3362🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_B...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...