MySQL phpmyadmin通用数据库替换SQL语句

2016-9-10 21:40

334

游子

56 字

几秒读完

 update ekyocn_archives set pubdate= Unix timestamp where id>=1 and id<=7000;
 update ekyocn_archives set senddate= Unix timestamp where id>=1 and id<=7000;
 update websmt_archives set pubdate= Unix timestamp where id>=1 and id<=7000;
 update websmt_archives set senddate= Unix timestamp where id>=1 and id<=7000;
 update dede_archives set pubdate= Unix timestamp where id>=1 and id<=80000;
 update dede_archives set senddate= Unix timestamp where id>=1 and id<=80000;

Unix timestamp 为时间戳！这是一个Dede程序批量更新文章日期的SQL实例。

UPDATE 数据表名称 SET 数据表字段 = replace(数据表字段, ‘旧的‘,’新的‘);

mysql SQL语句通用SQL替换通用数据库替换