#update select
UPDATE oa_commonmenu INNER JOIN sys_menu ON oa_commonmenu.menuname=sys_menu.Menu_name SET oa_commonmenu.menuid=sys_menu.Menu_id;
#alter table
alter table oa_commonmenu Add column menuid int null AFTER empid
#后续继续添加
原文：http://www.cnblogs.com/seanchang/p/7891239.html