2019独角兽企业重金招聘Python工程师标准>>> select a.*, @r:=@r+1 as r_num from ih_area_info a, (select @r:=100) b; 2.查看表所有字段。可以用来查看注释。 show full columns from ih_house_info; 转载于:https://my.oschina.net/tplinuxhyh/blog/796224