mysql 语句积累

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;