A batch script or shell script can easily be written to do this. -Sheeri
On 2/20/06, Daniel Kasak <[EMAIL PROTECTED]> wrote: > I've got some import scripts that are giving me trouble. > > Some MOFOs keep changing the format of the data they give us, and > sometimes I loose half the records. When this happens, I change the line > terminator from \r\n to \n ... or from \n to \r\n. > > It's starting to get to me. Is there any way to ease my pain here, short > of importing with one format, counting the number of records, truncating > the table, importing wit the other format, counting the number of > records, and then selecting the format with the most number of records? > > -- > Daniel Kasak > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
