在一个变量中以列表形式获取MYSQL列值

SELECT column_name FROM table_name;

import mysql.connector

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

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

# 执行查询语句
query = "SELECT column_name FROM table_name;"
cursor.execute(query)

# 获取查询结果
results = []
for (value,) in cursor:
    results.append(value)

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

# 打印查询结果
print(results)

import java.sql.*;

public class MySQLExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://your_host/your_database";
        String user = "your_username";
        String password = "your_password";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            String query = "SELECT column_name FROM table_name;";
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(query);

            // 获取查询结果
            List<String> results = new ArrayList<>();
            while (rs.next()) {
                String value = rs.getString("column_name");
                results.add(value);
            }

            // 打印查询结果
            System.out.println(results);

            rs.close();
            stmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}