make you text file format same as the table format . then use mysqlimport database_name table_name.txt
by default mysqlimport need tab delimited text. if you need ; or other use --fields-terminated-by= http://dev.mysql.com/doc/mysql/en/mysqlimport.html Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.dalar.net ----- Original Message ----- From: "Robin Lynn Frank" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 8:02 PM Subject: Importing from plain text? -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 My apologies for so basic a question, but I am just getting started with mysql. I have a text file that looks like this: text other text text2 othertext2 [...] I want the text in the left column in one field and the text in the righ column in the other field. I've been looking thru the docs, but am unsure of what I am seeing. Can someone point me to an example? TIA. - -- Robin Lynn Frank Director of Operations Paradigm-Omega, LLC ====================== A bug in the code is worth two in the documentation. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Sed quis custodiet ipsos custodes? iD8DBQFBGlEko0pgX8xyW4YRAxmkAJ9lEM6RNUMrKvU3p8MwpKXbV/JJ1ACeJMfc RRUmJEs6tw2h65IagfylVHQ= =Cw38 -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
