mysql 循环遍历表字段

DELIMITER //

CREATE PROCEDURE TraverseFields()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE field_name VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'your_database_name' AND TABLE_NAME = 'your_table_name';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO field_name;
        IF done THEN
            LEAVE read_loop;
        END IF;
        -- 在这里对field_name执行你需要的操作
        SELECT CONCAT('Processing field: ', field_name);
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL TraverseFields();

import mysql.connector

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

mycursor = mydb.cursor()

mycursor.execute("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'your_database_name' AND TABLE_NAME = 'your_table_name'")

for x in mycursor:
  print(x)