导入表字段数据/替换表字段语句

导入表字段数据
insert into tnews(User,CtlgID,CtlgIDStr,CtlgName,FirstEditTime,LastEditTime,Title,content)
select 'admin','76','3,76','签证信息',date,date,title,content from gg where type='签证信息'

替换表字段语句

update R_area set webphone=replace(webphone,'webmaster@jobwork.cn','0772-7357962')