[SQL] MySQL and Goto Symbol #1742
Comments
|
Hello, I have got the SQL.sublime-syntax file, but have no idea to play with it or its copy. |
|
@hl1m14, I had tried to play with custom package containing alternative language synax file (here's an example of syntax package: https://github.com/bortoloso/ORACLE_SUBLIME_SYNTAX). You can copy basic SQL sublime-syntax yml-file to your package directory and change it on your own. Don't forget to change its name value. Then you can edit syntax file in one tab and test it within another tab (change its syntax highlighting with Command palette). What you want is to detect specific scope properly (it seems it is an |
|
Looks good on #3046. Code below for easier copy/paste: drop table `contents`;
create table `contents` ();
create table if not exists `users` ();
create table if not exists `accounts` ();
create table if not exists `camps` ();Funny as of this writing, GitHub's language parser doesn't do the right thing. |
|
Yes, it's okay now. Thank you! |
Hello, I'm facing an issue:
As you can see, symbols index is wrong around
CREATE TABLE IF NOT EXISTS table_name— ST thinks that table name isIF.Also I've just found that
CREATE ALGORITHM=MERGE VIEW view_nameis out of index at all.When I skip the
ALGORITHM=MERGEdeclaration, it works fine.Is seems, that > the SQL syntax that ships with Sublime is a bit old and perhaps doesn't cover the syntax for MySQL.
Then i've found the SQL.sublime-syntax file and played with its copy. It's not very hard to fix my problem with Symbols, but generally there are lots of syntax issues with MySQL.
Proposal: create separate syntax-highlighting config containing actual syntax definitions (as of MySQL 8.0 or at least version 5.7).
The text was updated successfully, but these errors were encountered: