JDBC DatabaseMetaData#getTables()返回:错误1463 (42000)：HAVING子句中使用了非分组字段'TABLE_TYPE‘

String query = "SELECT TABLE_TYPE FROM your_table GROUP BY TABLE_TYPE HAVING condition";

import java.sql.*;

public class GetTablesExample {
    public static void main(String[] args) {
        try {
            // 创建数据库连接
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // 获取DatabaseMetaData对象
            DatabaseMetaData metaData = connection.getMetaData();

            // 获取表信息
            ResultSet resultSet = metaData.getTables(null, null, null, new String[]{"TABLE"});

            // 遍历结果集
            while (resultSet.next()) {
                String tableName = resultSet.getString("TABLE_NAME");
                String tableType = resultSet.getString("TABLE_TYPE");
                String remarks = resultSet.getString("REMARKS");

                System.out.println("Table Name: " + tableName);
                System.out.println("Table Type: " + tableType);
                System.out.println("Remarks: " + remarks);
                System.out.println("-------------------------");
            }

            // 关闭连接
            resultSet.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}