ylrz_saas_pharmacy/java/scripts/ScanMasterLobsterCols.java

public class ScanMasterLobsterCols {
  static String[] cols = {"visible_company_ids","execution_mode","enable_content_personalization","enable_flow_personalization","strict_fixed_workflow","auto_start_instance_on_tag","template_kind","source_template_id"};
  public static void main(String[] a) throws Exception {
    Class.forName("com.mysql.cj.jdbc.Driver");
    java.sql.Connection c = java.sql.DriverManager.getConnection(
      "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?allowMultiQueries=true","root","Ylrz_1q2w3e4r5t6y");
    for (String col : cols) {
      java.sql.ResultSet r = c.createStatement().executeQuery(
        "SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='company_workflow_lobster' AND COLUMN_NAME='"+col+"'");
      r.next();
      System.out.println(col + "=" + (r.getInt(1)>0));
    }
    c.close();
  }
}