> Greetings, > > I have an application that creates an SQL file from the data it > produces, but in some of that data, there might be a , or ' which > mysqlimport does not like. I need to use the mysqlimport utility, and I am > wondering if there is a way around this. I admit I have not tried yet, but > if my application writes the data beginning and ending with "'s would that > solve my problem? > > Thanks, > - Chris
if you have a windows machine that you can use for a front end to your mysql server, download corereader from http://corereader.com/ . it's free. it does point and click queries, so it's very fast except for making the data connection. run a query containing the apostrophe. then open corereader's sql frame to see its sql statement. it'll show you how to mask delimiters. ( because it's so powerful, corereader contains safeguards that prohibit updates, so you cannot update directly from it. ) -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
