ylrz_saas_pharmacy/java/scripts/ScanAllSchemas.java

public class ScanAllSchemas {
  public static void main(String[] a) throws Exception {
    Class.forName("com.mysql.cj.jdbc.Driver");
    java.sql.Connection m = java.sql.DriverManager.getConnection(
      "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?allowMultiQueries=true","root","Ylrz_1q2w3e4r5t6y");
    java.sql.Statement s = m.createStatement();
    java.sql.ResultSet rs = s.executeQuery(
      "SELECT TABLE_SCHEMA FROM information_schema.TABLES WHERE TABLE_NAME='company_workflow_lobster' ORDER BY 1");
    while (rs.next()) {
      String db = rs.getString(1);
      java.sql.Connection c = java.sql.DriverManager.getConnection(
        "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/"+db+"?allowMultiQueries=true","root","Ylrz_1q2w3e4r5t6y");
      java.sql.ResultSet r2 = c.createStatement().executeQuery(
        "SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='company_workflow_lobster' AND COLUMN_NAME='visible_company_ids'");
      r2.next();
      System.out.println(db + " has_visible_col=" + (r2.getInt(1)>0));
      c.close();
    }
    m.close();
  }
}