# # # 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 'the field list'
; Bad SQL grammar []; Nested exception is Java. SQL. SQLSyntaxErrorException: Unknown column 'goods_id' in 'the field list'] with root cause

Java. SQL. SQLSyntaxErrorException: Unknown column 'goods_id' in 'the field list'
Why always say can't find this ID? Clearly I have ah, creates the name of the database with the inside of the entity with Mapper. Inside the XML is consistent, is the problem?


Problem statement

CodePudding user response:

The from?

CodePudding user response:

Select the field name from the name of the table for the order by the field name

CodePudding user response:

The statement is not complete, not From the table