mysql查询结果增加自增列中

SELECT 
    ROW_NUMBER() OVER (ORDER BY some_column) AS auto_increment_id,
    column1,
    column2,
    ...
FROM your_table;

SELECT 
    @row_number:=@row_number+1 AS auto_increment_id,
    column1,
    column2,
    ...
FROM your_table, (SELECT @row_number:=0) AS init;

CREATE TEMPORARY TABLE temp_table (
    auto_increment_id INT AUTO_INCREMENT PRIMARY KEY,
    column1 datatype,
    column2 datatype,
    ...
);

INSERT INTO temp_table (column1, column2, ...)
SELECT column1, column2, ...
FROM your_table;

SELECT * FROM temp_table;

CREATE TABLE your_table (
    auto_increment_id INT AUTO_INCREMENT PRIMARY KEY,
    column1 datatype,
    column2 datatype,
    ...
) AUTO_INCREMENT=100;