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, 4804👍, 0💬
Popular Posts:
How To Concatenate Two Character Strings? - MySQL FAQs - Introduction to SQL Basics If you want conc...
Can each Java object keep track of all the threads that want to exclusively access to it?
What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...
.NET INTERVIEW QUESTIONS - Can we use events with threading ? Yes, you can use events with thread; t...
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...