pengjiasong的专栏

用excel写公式导入到数据库 =CONCATENATE("insert   into   blog   (template_subject,email_sn,to_url ,from_url,title,email,cat_id)   values   ('",A1,"','",B1,"','",C1,"','",D1,"','",E1,"','",F1,"' ,0);")

UPDATE ecs_article SET art_desc = REPLACE(art_desc, SUBSTRING(art_desc, LOCATE('', art_desc),LOCATE('', art_desc)-LOCATE('', art_desc) + 7),'');