string connStr = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword";
string cmdStr = "select * from information_schema.TABLES where Table_NAME ='tbl_1_1_1_MeasurementData'";
using (MySqlConnection conn = new MySqlConnection(connStr))
{
MySqlCommand cmd = new MySqlCommand(cmdStr, conn);
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int count = reader.GetInt32(0);
if (count == 0)
{
MessageBox.Show("该表不存在!");
}
else if (count == 1)
{
MessageBox.Show("该表存在!");
}
}
}
c# 如何判断mysql表明是否存在。。。sql同理
最新推荐文章于 2024-08-13 01:02:58 发布