SQL Highlighting in SQL file insert

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 comments

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.

0

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)

0

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

0

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)

0

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 :)

0

Please sign in to leave a comment.