获取mysql的返回值

import mysql.connector

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

# 创建游标对象
mycursor = mydb.cursor()

# 执行SQL查询
mycursor.execute("SELECT * FROM customers")

# 获取单行数据
result = mycursor.fetchone()
print(result)

# 获取多行数据
results = mycursor.fetchall()
for row in results:
    print(row)

const mysql = require('mysql');

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

// 连接到数据库
connection.connect();

// 执行SQL查询
connection.query('SELECT * FROM customers', function (error, results, fields) {
  if (error) throw error;
  console.log(results);
});

// 关闭连接
connection.end();