mysql sql遍历结果集

DECLARE cur CURSOR FOR SELECT * FROM your_table;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur;
read_loop: LOOP
    FETCH cur INTO @var1, @var2;
    IF done THEN
        LEAVE read_loop;
    END IF;
    -- 处理每一行数据
END LOOP;
CLOSE cur;

SELECT * INTO OUTFILE '/path/to/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '
'
FROM your_table;

START TRANSACTION;
INSERT INTO target_table (col1, col2) VALUES (1, 'a'), (2, 'b'), (3, 'c');
COMMIT;

import mysql.connector

cnx = mysql.connector.connect(user='user', password='password', host='host', database='database')
cursor = cnx.cursor(dictionary=True)

query = "SELECT * FROM your_table"
cursor.execute(query)

for row in cursor:
    # 处理每一行数据
    pass

cursor.close()
cnx.close()