sql查询并插入数据

INSERT INTO R_ADVERT  (    ID,    TITLE,    BUTTON,    DESCRIPTION,    IMAGE,    HREF,    STATUS  )  select    ID,    TITLE,    BUTTON,    DESCRIPTION,    IMAGE,    HREF,    STATUS  from CMRIA.R_ADVERT;