select a.*, :=@r+1 as r_num from ih_area_info a, (select :=100) b;
2.查看表所有字段。可以用来查看注释。
show full columns from ih_house_info;
本文共 174 字，大约阅读时间需要 1 分钟。
select a.*, :=@r+1 as r_num from ih_area_info a, (select :=100) b;
2.查看表所有字段。可以用来查看注释。
show full columns from ih_house_info;
转载于:https://my.oschina.net/tplinuxhyh/blog/796224