T

报错：Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6feb46b8]2021-04-26 10:25:06.643 ERROR 5924 --- [io-8080-exec-26] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] i

单表 查询 条件删除（这样写自己玩玩可以，这样写真是多此一举）注意单表查询删除 如果是这样写（DELETE FROM dim_people_copy where id=(select id from dim_people_copy where id=11038) ）是报错的正确的写法DELETE FROM dim_people_copy where id=(select * from ( select id from dim_people_copy where id=11038)

1.把B表的数据查询出新增到A表去INSERT INTO a(id,name) SELECT b.id as id,b.name as name FROM b;2.B表的字段满足不了A的情况下‘name’是对应type ，now()是对应的create_dateINSERT INTO dim_attach (type,bill_id,url,create_date) select 'name', a.id AS bill_id, a.head_address AS url,now()FR

在新增的时候报了这个异常java.sql.SQLException: Field ‘id’ doesn’t have a default value其实这个很简单 就是 你的Mysql数据库没有设置自动递增：刚才那就话不就是字段“id”没有默认值在数据库加上自动递增 别忘了主键也加上 就解决了 ...

报错org.apache.catalina.core.StandardWrapperValve invoke严重: Servlet.service() for servlet [dispatcherServlet] in context with path [/video_analysis] threw exception [Request processing failed; nested ...

select * from actorwhere date_format(t_tate,‘%Y-%m-%d00:00:00’)>=‘2019-12-18’ AND date_format(t_tate,‘%Y-%m-%d00:00:00’)<=‘2019-12-20’

解决：sql的类型和java实体类的类型不一致造成的 把实体类换成和数据库相对应的数据类型就可以了