`

Column 'XXX' not found.

阅读更多
hibernate+mysql
Column 'XXX' not found.
2013-59-03 10:59:26SQL Error: 0, SQLState: S0022
2013-59-03 10:59:26Column 'XXX' not found.

将以上sql粘贴到mysql工具中执行完全没有任何问题,这就怪了。

最后折腾处理如下:

select * from (原来的查询sql) as 别名

就OK了
分享到:
评论

相关推荐

    unigui0.83.5.820

    - 0000723: DBGrid: numeric column is not aligned to right - 0000722: Setting Align := alCenter on DBGridColumns does not work - 0000715: OmniHTTPD and UniGUI ISAPI - 0000724: Runtime assignment for...

    EhLib 9.1.024

    can be found in the file - About EhLib 9.1 Eng.doc To install a new version of the library in the IDE, use the installation program .\Installer\EhLibInstaller.exe If, at the installation have any ...

    oracle 存储过程的基本语法

    EXIT WHEN C_USER%NOTFOUND; -- 当游标到达末尾时退出循环 do something; END LOOP; CLOSE C_USER; ``` 9. **PL/SQL Developer 调试** PL/SQL Developer是一款强大的Oracle开发工具,它提供了一个测试窗口来...

    ehlib_vcl_src_9_3.26

    can be found in the file - About EhLib 9.2 Eng.doc To install a new version of the library in the IDE, use the installation program .\Installer\EhLibInstaller.exe If, at the installation have any ...

    oracle存储过程学习实例文档 创建调用

    EXIT WHEN cursor_name%NOTFOUND; -- 处理每一行的数据 END LOOP; CLOSE cursor_name; END; ``` 这里,`cursor_name`是游标的名称,`SELECT`语句定义了结果集,`var1, var2`用于存储当前行的值。 3. **Java...

    乐优商城.xmind

    ResponseEntity(HttpStatus.NOT_FOUND) 返回404没找到 ResponseEntity.ok 返回ok状态 service 开始分页 通用分页拦截器 PageHelper.startPage(page,row); 过滤 Example查询 Example example = new ...

Global site tag (gtag.js) - Google Analytics