mysql row number 解决:
set @i=0;
select column_names,@i:=@i+1 as order_num from table_name where condition order by column_names;
select数据导出:
select column_names from table_name order by column_names into outfile 'C:\data.sql';
阅读(1526) | 评论(0) | 转发(0) |