Alternatively, you can parse the text files using application logic (java, c++, etc) and then after extracting (and cleaning) your data insert them into mysql.
matter of fact we do something very similar - read from a host of text files - massage the data and then send them to be inserted into the db. HTH, Anoop On 6/22/05, Jigal van Hemert <[EMAIL PROTECTED]> wrote: > From: <[EMAIL PROTECTED]> > > That's what I Ntried to say, yes :) The main problem is the decimal comma > > in the amounts. > > What about reading the data into the table and storing the 'amount' in > varchar for now. Then you can run an update query in which you replace the > decimal comma with a decimal point and store that in the float field > (emptying the varchar in the process). > > UPDATE `table` SET `amount`= REPLACE( `v_amount`, ',' , '.'), `v_amount` = > NULL WHERE `v_amount` IS NOT NULL; > > Works like a charm ;-) > > Regards, Jigal. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Thanks and best regards, Anoop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
