处理mysql中有不连续的数据ID编号时，使其ID连续的解决办法

CREATE VIEW your_table_view AS 
SELECT    
	ROW_NUMBER() OVER (ORDER BY id) AS display_id,    		other_columns
FROM    
	your_table;

INSERT INTO 
	myNewTable 
	SELECT 
		* 
	FROM 
		myView;