Allen Weeks wrote:
It's possible, but it's a hassle.Hello All, Maybe I am not searching the documentation correctly or am I correct in finding there is not method of directing importing a fixed length text file into a MySQL table?I hope I just missed the reference. Could someone point me to it. Any assistance is greatly appreciated. Allen It's documented in: http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html About half way down the page, it says: If theSo you have to set up a table with the exact field lengths in the 'create table' definition, and then use 'load data infile' with the options 'fields terminated by' and 'fields enclosed by' both empty strings ( '' ). Dan --
IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au |
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]