sql查询库中是否存在该表
案例:
SHOW TABLES IN dreamweb_gjfgw WHERE Tables_in_dreamweb_gjfgw =‘g_app_data_service_log’
格式:
SHOW TABLES IN 数据库名称 WHERE Tables_in_数据库名称 =‘表名称’
Sql sql = new Sql("SHOW TABLES IN dreamweb_gjfgw WHERE Tables_in_dreamweb_gjfgw ='g_app_data_service_log';");
DataTable dataTable = DBManager.getDataTable(sql);
更多内容请见原文,原文转载自:https://blog.csdn.net/weixin_44519496/article/details/120583550
标签:Tables,SHOW,gjfgw,库中,Mysql,dreamweb,某表,WHERE From: https://www.cnblogs.com/wangchuanxinshi/p/17094857.html