通过 Node.js 程序显示 MySQL 数据库中的表列表，我们需要使用 mysql2 库的 query() 函数执行 SHOW TABLES 语句，如下所示 −

sql= "SHOW TABLES FROM DATABASE";
con.query(sql);

通过 Java 程序显示 MySQL 数据库中的表列表，我们需要使用 JDBC 函数 executeUpdate() 执行 SHOW TABLES 语句，如下所示 −

String sql = "SHOW TABLES FROM DATABASE";
statement.executeQuery(sql);

通过 Python 程序显示 MySQL 数据库中的表列表，我们需要使用 MySQL Connector/Python 的 execute() 函数执行 SHOW TABLES 语句，如下所示 −

show_table_query = "SHOW TABLES FROM DATABASE"
cursorObj.execute(show_table_query);

var mysql = require('mysql2');
var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "Nr5a0204@123"
});

  //连接到 MySQL
  con.connect(function (err) {
  if (err) throw err;
  console.log("Connected!");
  console.log("--------------------------");

  sql = "CREATE DATABASE TUTORIALS;"
  con.query(sql);

  sql = "USE TUTORIALS;"
  con.query(sql);

  sql = "CREATE TABLE CUSTOMERS (ID INT NOT NULL, NAME VARCHAR(20) NOT NULL);"
  con.query(sql);

  sql = "CREATE TABLE ORDERS (OID INT NOT NULL, CUSTOMER_ID INT);"
  con.query(sql);

  sql = "SHOW TABLES;"
  con.query(sql, function(err, result){
    if (err) throw err
    console.log(result);
  });
});               

输出

产生的输出如下所示 −

Connected!
--------------------------
[
  { Tables_in_tutorials: 'customers' },
  { Tables_in_tutorials: 'orders' }
]         

import java.sql.*;
public class JDBCconnection {
public static void main(String[] args){
    String url = "jdbc:mysql://localhost:3306/TUTORIALS";
    String username = "root";
    String password = "password";
    try{
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection connection = DriverManager.getConnection(url, username, password);
        Statement statement = connection.createStatement();
        System.out.println("Connected successfully...!");

        //显示表语句...!
        String sql = "SHOW TABLES FROM TUTORIALS";
        ResultSet resultSet = statement.executeQuery(sql);
        System.out.println("Tables in the current database: ");
        while(resultSet.next()) {
            System.out.print(resultSet.getString(1));
            System.out.println();
        }
        connection.close();
    }
    catch(Exception e){
        System.out.println(e);
    }
}
}                              

输出

得到的输出如下所示 −

Connected successfully...!
Tables in the current database: 
articles
blackpink
blog
courses
customer
customers
data   

import mysql.connector
#建立连接
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
#创建游标对象 
cursorObj = connection.cursor()
cursorObj.execute("SHOW TABLES")
tables = cursorObj.fetchall()
print("Tables in the database are:")
for table in tables:
    print(table[0])
cursorObj.close()
connection.close()                                         

输出

以上代码的输出如下所示 −

Tables in the database are:
books
novel
novels
tutorials_tbl