mysql函数怎么打印结果集

SELECT * FROM your_table;

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')

# 创建一个游标对象
cursor = cnx.cursor()

# 执行SQL查询
query = ("SELECT * FROM your_table")
cursor.execute(query)

# 获取并打印结果集
for row in cursor:
    print(row)

# 关闭游标和连接
cursor.close()
cnx.close()

<?php
try {
    // 创建PDO实例
    $pdo = new PDO('mysql:host=your_host;dbname=your_database', 'your_username', 'your_password');

    // 设置错误模式
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 准备SQL语句
    $stmt = $pdo->prepare('SELECT * FROM your_table');

    // 执行SQL语句
    $stmt->execute();

    // 获取并打印结果集
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        print_r($row);
    }
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}
?>

DELIMITER //

CREATE PROCEDURE PrintResult()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE v_row VARCHAR(255);
    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 v_row;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SELECT v_row;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

-- 调用存储过程
CALL PrintResult();