sql select statment中的错误 [英] error in sql select statment

问题描述

这是我转储时的sql语句

this is the sql statment when i dump it

"SELECT id FROM p_msgs WHERE (from_player_id=14 AND to_player_id=15) AND (msg_title=gbhjhghgjhgjgjhgjghj AND msg_body=gbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghj)"

与误差

and the error is

Unknown column 'gbhjhghgjhgjgjhgjghj' in 'where clause'

推荐答案

尝试：

Try:

"SELECT id FROM p_msgs WHERE (from_player_id=14 AND to_player_id=15) AND (msg_title='gbhjhghgjhgjgjhgjghj' AND msg_body='gbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghjgbhjhghgjhgjgjhgjghj')"

如果你不引用文本，SQL假定它是某种形式的变量名。

If you don't quote the text, SQL assumes it is a variable name of some form.

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