mysql怎么循环

DELIMITER //

CREATE PROCEDURE loop_example()
BEGIN
    DECLARE counter INT DEFAULT 1;

    WHILE counter <= 10 DO
        SELECT counter;
        SET counter = counter + 1;
    END WHILE;
END //

DELIMITER ;

CALL loop_example();

DELIMITER //

CREATE PROCEDURE loop_example()
BEGIN
    DECLARE counter INT DEFAULT 1;

    loop_label: LOOP
        IF counter > 10 THEN
            LEAVE loop_label;
        END IF;

        SELECT counter;
        SET counter = counter + 1;
    END LOOP loop_label;
END //

DELIMITER ;

CALL loop_example();

WITH RECURSIVE cte_loop AS (
    SELECT 1 AS counter
    UNION ALL
    SELECT counter + 1 FROM cte_loop WHERE counter < 10
)
SELECT * FROM cte_loop;

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

for counter in range(1, 11):
    cursor.execute("SELECT %s", (counter,))
    result = cursor.fetchall()
    for row in result:
        print(row)

db.close()