SQL Highlighting in SQL file insert

创建于 2019年01月16日 11:30

Hi everyone,

Hoping you can help me with this. I saw on a friends installation of PhpStorm the other day that when she was editing an insert SQL statement within a SQL file, the corresponding column names were highlighted as she moved through the "values" section of the insert.

I would really like for this to happen on my version of PhpStorm but as yet, I don't seem to have found the correct setting. Can anyone please point me in the correct direction?

5 条评论

Vasiliy Yur

创建于 2019年01月16日 19:07

I am sorry for the probably obvious question but what version of PhpStorm do you have installed currently?

Also, it would be fantastic if you could share a screenshot of the desired behaviour.

MarkTheMartian

创建于 2019年01月17日 12:18

Version : 2018.3.3

On the screenshots, you can see where the cursor is on the second one. On the first one, the cursor was in the "email" section of "insert into user(id, email) values".

(hope this makes sense)

Eugene Morozov

创建于 2019年01月17日 21:51

It really should work out of the box.

Please try using this query:

INSERT INTO sometable (path, name, name2, name3, name4)
VALUES ('one', 'two', 'three', 'four', 'five'),
  ('one', 'two', 'three', 'four', 'five');

And set the SQL dialect to MySQL, for instance.

Would it not do the trick for you?

http://recordit.co/w2mbybEkuB

MarkTheMartian

创建于 2019年01月21日 10:40

Hmm...
...It must be my colour scheme then :(

Do you know if there is a setting which controls the colour of this highlight? (I suspect that it's being highlighted in black, on a black background)

MarkTheMartian

创建于 2019年01月21日 10:59

Found it! (I think)

Settings > Editor > Color Scheme > General

identifier under carat & identifier under carat (write)

set the background (I had it as black)

Thanks for your help though :)

请先登录再写评论。