MYSQL 用select 不重复的结果插入到另一表

SET @@global.sql_mode= '';

INSERT INTO movies_copy2(id,directors,rate,title,casts,cover,year,types,country,lang,time,moveitime,comment_len,starts,summary,comments,imglist,movieurl,detaillink) select
id,directors,rate,title,casts,cover,detaillink,year,types,country,lang,time,movietime,comment_len,starts,summary,comments,imglist,movieurl from 某条movies group by title

posted @ 2024-04-26 21:08  myrj  阅读(1)  评论(0编辑  收藏  举报