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, 2553🔥, 0💬
Popular Posts:
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...