
数据库
北斗2018
努力,奋斗
展开
-
sql语句中出现column保留字报错
报错详情:SELECT id ,column from sys_shelf> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'column from sys_shelf' at line 1> 时间: 0.027s原来sql语句如下:SELECT i原创 2020-12-08 15:38:15 · 714 阅读 · 0 评论 -
mybatis报错:There is no getter for property named ‘id‘ in ‘class java.lang.Long‘
mybatis报错:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'id' in 'class java.lang.Long'xml中,sql如下:select dd.*from sys_mouldtype_device md,原创 2020-11-20 20:16:14 · 1929 阅读 · 1 评论 -
记一次新建外键约束失败---1215 - cannot add foreign key constraint
原因及解决方案:原因:1.外键在主表中没有建立索引2.外键在主从表类型不一致解决方法:1.给一个外键在主表中建立约束2.字段类型保持一致这两种情况,我都有遇到。原创 2020-11-13 10:35:59 · 92 阅读 · 0 评论