1.查看并优化字段的数据类型
select * from user_account PROCEDURE ANALYSE(1)\G;
2.mysql update更新用法
UPDATE footprints f,testnum t set f.sync_praises=t.sync_praises WHERE f.id=t.id ;
UPDATE footprints f JOIN testnum t on f.id=t.id SET f.sync_praises=t.sync_praises;
