MySQL恢复单一字段数据

Published on August 21, 2009 in Tech. 0 Comments Tags: MySQL.

1	UPDATE people_user AS p LEFT JOIN people_user_tmp AS t ON t.user_id = p.user_id SET p.user_pic = t.user_pic WHERE p.user_id<1871

Related Posts

January 18, 2012 -- MySQL regex_replace Function
June 9, 2011 -- 一天总结
September 13, 2010 -- MySQL锁表机制分析
September 9, 2010 -- HOWTO: configure MySQL’s my.cnf file
September 8, 2010 -- MySQL性能优化21 – 使用随机函数产生采样
September 8, 2010 -- MySQL性能优化20 – ORDER BY 操作的优化
September 8, 2010 -- MySQL性能优化19 – GROUP BY 操作的优化
September 8, 2010 -- MySQL性能优化18 – 使用 GROUP BY WITH ROLLUP 改善统计性能
September 8, 2010 -- MySQL性能优化17 – INSERT操作的优化
September 8, 2010 -- MySQL性能优化16 – InnoDB 存储引擎

0 Responses to “MySQL恢复单一字段数据”

Feed for this Entry Trackback Address

No Comments

Leave a Reply