未配置SQL方言(Phpstorm) [英] SQL Dialect is Not Configured (Phpstorm)

问题描述

我正在使用Google oauthorization2，但是遇到了问题

I am working on Google oauthorization2 and I encounter problem that

未配置SQL方言

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.

工具: PhpStorm 8+ 的MySQL 本地主机

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')");

推荐答案

转到File > Settings > Languages & Frameworks > SQL Dialects并为整个项目进行设置.

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

这篇关于未配置SQL方言(Phpstorm)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！