mysqlfor循环输出查询

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

cursor = db.cursor()

# 假设我们要查询1到10的记录
for i in range(1, 11):
    query = f"SELECT * FROM yourtable WHERE id = {i}"
    cursor.execute(query)
    result = cursor.fetchall()
    for row in result:
        print(row)

const mysql = require('mysql');

// 创建连接
const connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'yourusername',
  password : 'yourpassword',
  database : 'yourdatabase'
});

connection.connect();

// 假设我们要查询1到10的记录
for (let i = 1; i <= 10; i++) {
    const query = `SELECT * FROM yourtable WHERE id = ${i}`;
    connection.query(query, function (error, results, fields) {
        if (error) throw error;
        console.log(results);
    });
}

connection.end();

# Python示例
query = "SELECT * FROM yourtable WHERE id = %s"
cursor.execute(query, (i,))

// JavaScript示例
const query = 'SELECT * FROM yourtable WHERE id = ?';
connection.query(query, [i], function (error, results, fields) {
    if (error) throw error;
    console.log(results);
});