forums › forums › SQLyog › Using SQLyog › Error 1064
- This topic is empty.
-
AuthorPosts
-
-
February 11, 2003 at 12:56 am #13699
CalEvans
MemberThose 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?
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
MemberIs 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
MemberSorry 🙁 but there is no option to deactivate backticks
-
-
AuthorPosts
- You must be logged in to reply to this topic.