mysql row number 解决 及 select数据导出
时间：2008-06-19 来源：ruknow
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';
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';
相关阅读 更多 +
