Annoying underline in my sql statement

Hi, I have problem in the phpstorm,why is it that it will always underline my sql statement

example.

   sql = "select column1,column2 from users where id = '2'";

and it will show the tooltip "No data sources configure to run this SQL and provide advance code assistance.etc..
and also it follows "Please configure SQL dialect for this file. etc......".


bu this sql statement is working.it only just showing underline on it and  a tooltip.can you help me please how to fixed this.

I am working in phpmyadmin localhost,windows 7 O.S

Thank you in advance.

6 comments

Hi there,

You can turn off those inspections (if you do not need additional SQL support/checks) in Settings | Inspections | SQL

0

Hi thank you for the reply,..

Bazzik wrote:

Hi there,

You can turn off those inspections (if you do not need additional SQL support/checks) in Settings | Inspections | SQL

But i want also to have an sql support, i have question is this normal to have underline on sql statement if we want to have an sql support?


Thank you in advance.

0

If you want to have that *extra* sql support -- then you have to do what those inspections tell you to do:

  1. Define SQL Dialect for whole project / this file (Settings | SQL Dialects) -- http://www.jetbrains.com/phpstorm/webhelp/sql-dialects.html
  2. Setup Data Source (see "Database" tool window .. or "View | Tool Windows | Database") -- http://www.jetbrains.com/phpstorm/webhelp/database-tool-window.html
2

Bazzik wrote:

If you want to have that *extra* sql support -- then you have to do what those inspections tell you to do:

  1. Define SQL Dialect for whole project / this file (Settings | SQL Dialects) -- http://www.jetbrains.com/phpstorm/webhelp/sql-dialects.html
  2. Setup Data Source (see "Database" tool window .. or "View | Tool Windows | Database") -- http://www.jetbrains.com/phpstorm/webhelp/database-tool-window.html

Hi,  Can you help me please what data source should i will download,..I am using wampserver. i don't know what to download

Thank you in advance.

0

Hi Andriy Bazanov, Thank you so much your so helpfull..you save me.

:)

0

Please sign in to leave a comment.