Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Load Data Files into Tables with "mysqlimport"
How To Load Data Files into Tables with "mysqlimport"? - MySQL FAQs - Administrator Tools for Managing MySQL Server
✍: 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 | +-------------------+
2007-05-11, 4854👍, 0💬
Popular Posts:
Who Developed HTML? HTML was originally developed by Tim Berners-Lee while at CERN, and popularized ...
How To Assign Query Results to Variables? - Oracle DBA FAQ - Working with Database Objects in PL/SQL...
Can an anonymous class be declared as implementing an interface and extending a class? An anonymous ...
How To Specify Two Background Images on a Page? - CSS Tutorials - Page Layout and Background Image D...
How can you implement MVC pattern in ASP.NET? The main purpose using MVC pattern is to decouple the ...