Error 1064

This topic is empty.

Viewing 3 reply threads

Author

Posts
- February 10, 2003 at 8:30 pm #7678
  
  vandy
  Member
  
  Downloaded latest version (3.02) of SqlYog on Win2k. Am accessing a mysql database on a networked linux server. Connection seems to work OK but when I try to open a database, SqlYog gives a 1064 error on SQL syntax. If I then look at the history tab, I see the SQL statement that SqlYog generated:
  
  show table status from `taskman`
  
  There should be no quotes around taskman, and there should be a semicolon after the statement.
  
  Don't know why SqlYog is generating SQL like this. The only thing I can possibly conceive is that the latest version of MySQL accepts this format and I'm not running the latest version….
  
  Any help would be appreciated.
- February 11, 2003 at 12:56 am #13699
  
  CalEvans
  Member
  
  Obligatory link to the docs.
  
  Those are not quotes, they are backticks. MySQL allows them around table and field names work around the restriction of reserved words and special chrs. While I don't personally use them in my coding, they are a safety measure in SQLyog to make sure that it does not try and execute queries with reserved words in them. (try show table status from `mysql`; in a mysql client.. It should work.)
  
  The ; is required and being used but it is not being echoed in the history file. Not sure why but this is not a bug. SQLyog IS putting them in where it counts, in the actual command stream. Check the log file from your mysql server. They should be there. (Mine always are)
  
  I agree that there is a problem somewhere but these are it.
  
  What version of mysql are you using?
  
  Obligatory link to the docs.
  
  The current syntax of SHOW TABLE STATUS is new in version 3.23. The previous version (SHOW STATUS `mysql`;) does work with my version of 3.23.54a. I'm not sure when it stopped working but you could be right in the fact that it's a version think.
  
  HTH,
  
  =C=
- May 13, 2003 at 7:07 pm #13700
  
  hanse
  Member
  
  Is there a possibility to deactivate these backticks?
  
  SQLyog has problems with version 3.22.32. I know it's old but I must administrate this mysql version. After 3.23 and newer the table names are quoted. The SQLyog uses this syntax and nowhere I found any option to deactivate the quotes. Exist a solution?
  
  That's the reason why I MUST use MySQL-Front this moment. But I like SQLyog …
- May 15, 2003 at 2:16 pm #13701
  
  Ritesh
  Member
  
  Sorry 🙁 but there is no option to deactivate backticks
Author

Posts