在mysql中的关键字 [英] In keyword in mysql

问题描述

我在sql yog中运行Mysql中的查询。

Helo to all I am running a Query in Mysql in sql yog..

我的查询是

从个人中选择*其中id IN（" select  id from user where name ='golds'）

Select * from personal where id IN("select  id from user where name='golds')

运行此查询错误即将来临。是否有任何错误plz tell

Running this query error is coming.Is there any error plz tell

 

推荐答案

有几个错误。第一个错误是，这是Microsoft SQL Server的论坛，更确切地说是即将发布的SQL Server版本。所以这不是你可以期待关于MySQL的好答案的地方。

There are several errors. The first error is that this is a forum for Microsoft SQL Server, more precisely the coming version of SQL Server. So this is not the place where you can expect good answers about MySQL.

你的查询中的错误是你的查询中有一个意外的双引号。只需删除它，您的查询就应该运行。

The error in your query is that you have an unexpected double quote in your query. Just remove it, and your query should run.

这篇关于在mysql中的关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！