6 Replies Last post: Mar 18, 2013 11:08 PM by carmz  
carmz Newbie 29 posts since
Feb 24, 2013
Currently Being Moderated

Mar 18, 2013 8:30 PM

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.

Andriy Bazanov Master 4,194 posts since
May 28, 2010
Currently Being Moderated
Mar 18, 2013 8:40 PM in response to: carmz
Re: Annoying underline in my sql statement

Hi there,

 

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

Andriy Bazanov Master 4,194 posts since
May 28, 2010
Currently Being Moderated
Mar 18, 2013 8:58 PM in response to: carmz
Re: Annoying underline in my sql statement

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
Andriy Bazanov Master 4,194 posts since
May 28, 2010
Currently Being Moderated
Mar 18, 2013 10:14 PM in response to: carmz
Re: Annoying underline in my sql statement

WAMP means MySQL -- this blog post should have all the answers: http://blog.jetbrains.com/webide/2012/11/sql-support-and-database-tools/

More Like This

  • Retrieving data ...