[sql] add support for mysql

[llewelynrex]

• VSCode Version: 0.10.11
• OS Version: Windows 7 Professional

Steps to Reproduce:

I have a \ character defined as a string in an update query. The Syntax highlighting is incorrectly escaping the following ' and displaying the rest of the script as a string. I am using UTF-8 Encoding with SQL as the language. Below two screenshots:

This is the same piece of script in SSMS.

[aharpervc]

Possibly related: atom/language-sql#13 (probably using the same grammars?). Whoever fixes it first should send a patch to the other, if so.

[aeschli]

We're using https://github.com/textmate/sql.tmbundle.
From the discussion in atom/language-sql#13 it looks like this is about different dialects of SQL. You seem to use the MySQL dialect, where '' is not an escape character.
Just removing it wouldn't work, as it would break other users.
I guess we need to add separate language support for MySQL.

[aharpervc]

This isn't a MySQL thing, even though the OP described it that way, or otherwise stated, it is also a SQL Server syntax issue. In any case, separate sql dialects probably need separate rules. There is also the question of what the default should be.

[aeschli]

This got fixed in the meantime, likely by the switch of the SQL grammar from https://github.com/Microsoft/vscode-mssql