search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.21k stars 326 forks source link

backtick in identifiers #731

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 730 created by webyog on 2008-05-28T12:01:07.000Z:

We do not support backtick in identifiers in GUI. Any create..alter.. drop operation on any type of objects will fail.

SQLyog will "Create table my`table"

correct is "Create table my``table"

atulwy commented 9 years ago

Comment #1 originally posted by webyog on 2011-02-19T12:28:46.000Z:

example query generated by SQLyog (that fails)

create table test.xy( ab int NOT NULL AUTO_INCREMENT , t text , PRIMARY KEY (ab`) )

atulwy commented 9 years ago

Comment #2 originally posted by webyog on 2013-08-31T11:47:37.000Z:

It also fails in exporting when backticks are used in database, table etc. identifers. Probably also several places in SJA wizards and more.

11.23 had a fix for backticks in column identifiers: http://blog.webyog.com/2013/08/29/sqlyog-mysql-gui-11-23-released/ "Exporting to a SQL-dump failed to escape properly, if a view contained columns with backtick(s) in the column identifier. Please note that this is a partial fix for backticks in identifiers only as columns names with backticks (in both tables and views) will now be exported correctly, but database and table etc. names with backticks still don’t. We don’t recommend using backticks in an identifier at all (even though it is legal from a ‘formalistic point of view’ in MySQL 5.1+)."

Kartikwy commented 9 years ago

Also autocomplete does not handle tables with a backtick and apostrophe in identifier.