一、查询取别名 SELECT b.bank_name FROM tpc_bank_enum b WHERE b.id = 1; 二、更新取别名 UPDATE `tpc_bank_enum` b SET b.add_time = '2016-5-1' WHERE b.id = 45; 三、删除取别名(注意和查询更新不同) DELETE t FROM tpc_bank_enum t WHERE t.id = 45;