Unknown column ‘id‘ in ‘field list‘

Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘id’ in ‘field list’
意思是数据库找不到id这个列，将下面的id改成goodID就好了

public class TbGoods {
//    自增id
//    @TableId(value = "goodid",type = IdType.AUTO)
//   雪花算法
//错误写法
   @TableId(type = IdType.ASSIGN_ID,value = "id")//枚举注解,使用
//正确写法   
   @TableId(type = IdType.ASSIGN_ID,value = "goodID")//枚举注解,使用ID_WORKER策略,全局唯一ID，数据库设置自增也没用
   private Long goodid;
   private String goodname;
   private int num;
   private double price;
   private int typeid;
   private String img;
}