开发者社区数据库文章正文

Unknown column ‘张三‘ in ‘where clause‘

2023-06-12 62

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介： Unknown column ‘张三‘ in ‘where clause‘

报错信息：Unknown column '张三' in 'where clause'

报错原因：通常这个报错是因为数据库表中不存在这个字段，但是我这里不是这个问题，我这里是因为我的sql语句有点问题

原来的sql语句：String sql = "select * from returns where name="+name;

修改后的sql语句：String sql = "select * from returns where name="+" ' "+name+" ' ";

这里报错是因为sql语句中的name是中文，所以需要加上单引号，不然会报错

文章标签：

SQL

数据库

骚戴

风水道人

2月前

SQL 关系型数据库 MySQL

Unknown column ‘xx’ in ‘on clause’

风水道人

9 0 0

阿甘兄

6月前

数据库

解决which is not functionally dependent on columns in GROUP BY clause；...sql_mode=only_full_group_by

阿甘兄

44 0 0

道亦无名

8月前

存储 SQL 关系型数据库

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解决办法

道亦无名

87 0 0

zhangyaoya

10月前

关系型数据库 MySQL 数据库

View ‘information_schema.SCHEMATA‘ references invalid table(s) or column(s) or function(s) or define

zhangyaoya

140 0 0

凯小默

数据库

Incorrect table definition； there can be only one auto column and it must be defined as a key

凯小默

122 0 0

Incorrect table definition； there can be only one auto column and it must be defined as a key

torchstars

1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause

torchstars

172 0 0

1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause

nanke_yh

SQL 关系型数据库 MySQL

【已解决】SELECT list is not in GROUP BY clause and contains nonaggregated column

MySQL5.7.5后only_full_group_by成为sql_mode的默认选项之一，这可能导致一些sql语句失效。

nanke_yh

188 0 0

邵奈一2018

SQL 关系型数据库 MySQL

报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat

邵奈一2018

280 0 0

报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregat

Lux_Sun

关系型数据库 MySQL 数据库

MySQL - Column 'id' in where clause is ambiguous

Lux_Sun

588 0 0

Lux_Sun

SQL 关系型数据库 MySQL

MySQL - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

Lux_Sun

161 0 0

Unknown column ‘张三‘ in ‘where clause‘

热门文章

最新文章

相关电子书