Hi, Here is the error:
> mysql -u odbc database < zzz.sql ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL serv er version for the right syntax to use near '´¬¬ /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1 But I have discovered that this happends only if I re-save the .sql file with TextPad. After saving the file, even without modifying it, the file size decreases with 3 bytes, and I think TextPad saves the file but without the byte order mark for UTF-8. So MySQL might think that the file is ANSI, and detect some bad chars. Teddy ----- Original Message ----- From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Saturday, December 24, 2005 23:47 PM Subject: Re: 2 questions > Hello. > > > It gives an error near some special chars (because the file is not >ANSI). > > Please, could you provide the error message. Check if it disappears if you > perform the dump with --quote-names option. > > > The second question is related to "explain". Is there a "explain" > >function for update as there is for "select"? > > > An update statement is optimized like a SELECT query with the additional > overhead of a write. So you can take the optimizer plan from the > corresponding SELECT statement (with the same WHERE clause and table > references). > > > > Octavian Rasnita wrote: > > Hi, > > > > I have used mysqldump with 5.0.15-nt and I have seen that it saves the file > > in UTF-8 format. > > This is OK, but if I try to run: > > > > mysql database < saved_file.sql > > > > It gives an error near some special chars (because the file is not ANSI). > > > > If I convert the file as ANSI, I can import the data from it into MySQL > > without problems. > > > > Am I doing something wrong? > > > > The second question is related to "explain". Is there a "explain" function > > for update as there is for "select"? > > > > Thank you. > > > > Teddy > > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > 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]
