一、判断某数据库是否存在
(一)单纯判断数据库dbname是否存在
SQL语句为:
SELECT * FROM information_schema.SCHEMATA where SCHEMA_NAME='dbname';
c#实现代码如下:
String sqlConn = "server=10.0.0.3;port=3306;user=root;password=mypassword;";
MySqlConnection conn = new MySqlConnection(sqlConn);//
string sqlDB = "SELECT * FROM information_schema.SCHEMATA where SCHEMA_NAME='dbname';";
MySqlDataAdapter adp = new MySqlDataAdapter(sqlDB, conn);
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
MessageBox.Show("数据库已存在");
else
MessageBox.Show("数据库不存在!");
(二)如果判断数据库dbname存在,则删除
SQL语句如下:
DROP DATABASE IF EXISTS `test1`;
MySqlCommand cmd=new MySqlCommand(string.Format("DROP DATABASE IF EXISTS 'test';"));
cmd.ExecuteNo