一亩三分地网
Home >  > mysql把一表某栏目的某字段值插入另一表

mysql把一表某栏目的某字段值插入另一表

4

insert into phome_enewskey(title,titleurl) select title,titleurl from phome_ecms_article where classid=32;

insert into phome_enewskey(title,titleurl) select title,titleurl from phome_ecms_article where classid=33;

insert into phome_enewskey(title,titleurl) select title,titleurl from phome_ecms_article where classid=49;

insert into phome_enewskey(title,titleurl) select title,titleurl from phome_ecms_wx where classid=12;

Comment (14)
Trackback (0)
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表