SQL Dialect is Not Configured (Phpstorm)

Question

I am working on Google oauthorization2 and I encounter problem that

SQL dialect is not configured

That's why my query is not executing and data is going to table.

I have listed below both of queries where I encounter problem.

Tools: PhpStorm 8+ MySQL Localhost

$user_exist = $mysqli->query("SELECT COUNT(google_id) as usercount FROM google_users WHERE google_id=$user_id")->fetch_object()->usercount;

$mysqli->query("INSERT INTO google_users (google_id, google_name, google_email, google_link, google_picture_link)
        VALUES ($user_id, '$user_name','$email','$profile_url','$profile_image_url')");

Solution 1

Head to File > Settings > Languages & Frameworks > SQL Dialects and set it for the whole project.

Solution 2

This is a screenshot of how to do that inside the settings:

This is on version 2016.3

Comments

[greaterKing]

For Mac Version: PhpStorm > Languages & Frameworks > SQL Dialects

[Ojonugwa Jude Ochalifu]

What to you mean by "set it for the whole project"?

[Michael Bolli]

@ojonugwaochalifu to select your project's topmost folder and set the dialect there.

[KaKa]

@ojonugwaochalifu to change SQL dialect PhpStorm uses for a file, a directory, or the entire project, click an item and then choose a dialect from a drop down list.

[Unni Babu]

very helpful. Thank you

[Junaid Atari]

Thanks! you just saved me!

[Csaba Toth]

Works for PyCharm and I guess for any IntelliJ derivative as well