Daily Archives: 2014年03月13日

常用的几个SQL

update pre_portal_article_content set content=ltrim(content) where aid = 3233
update pre_portal_article_content set content = replace(‘content’,’<img src=“s/‘,’s/’)
update pre_portal_article_title set dateline = aid where aid > 3000
update pre_portal_article_title set dateline = CONCAT(aid, ‘000’) where aid > 3000