mysql 检查数据库版本信息

mysql --version

SELECT VERSION();

import mysql.connector

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

mycursor = mydb.cursor()

mycursor.execute("SELECT VERSION()")

result = mycursor.fetchone()

print("MySQL version:", result[0])

import java.sql.*;

public class MySQLVersionChecker {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/";
        String user = "yourusername";
        String password = "yourpassword";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            DatabaseMetaData metaData = conn.getMetaData();
            System.out.println("MySQL version: " + metaData.getDatabaseProductVersion());
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'yourusername',
  password: 'yourpassword'
});

connection.connect();

connection.query('SELECT VERSION()', (error, results, fields) => {
  if (error) throw error;
  console.log('MySQL version:', results[0]['VERSION()']);
});

connection.end();