### SQL: SELECT goods_id,goods_name,goods_intro,goods_category_id,goods_img,goods_carousel,goods_price,goods_pro_price,stock_num sub_title,goods_sell_status,create_date ORDER BY goods_id desc limit ?,?
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'goods_id' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'goods_id' in 'field list'] with root cause
java.sql.SQLSyntaxErrorException: Unknown column 'goods_id' in 'field list'
為什么一直說找不到這個ID啊?明明我就創建有啊。資料庫里面的名稱跟entity里面的跟Mapper.xml里面寫的都是一致的,難道是這個的問題嗎?


出問題的陳述句

uj5u.com熱心網友回復:
from呢?uj5u.com熱心網友回復:
select 欄位名 from 表名 order by 欄位名
uj5u.com熱心網友回復:
陳述句不完整,沒有From table轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/18262.html
標籤:MySQL
上一篇:fetch時報243錯誤
