201711122215->mysql增加database

目的:链接数据库实现库的新增

详细代码:

------------------------------------------------------------------------------直接创建------------------------------------------------------------------------------

string sqlconst = "server=localhost;user=root;database=mytestsql;port=3306;password=root;";

 MySqlConnection connect = new MySqlConnection(sqlconst);
 connect.Open();

 Console.WriteLine("成功链接mysql...");

MySqlCommand command = new MySqlCommand("create database testtesttest", connect);
            try
            {
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine("增加数据库失败..." + ex.ToString());
            }

connect.Close();

------------------------------------------------------------------------------直接创建------------------------------------------------------------------------------

------------------------------------------------------------------------------检测创建------------------------------------------------------------------------------

string sqlconst = "server=localhost;user=root;database=mytestsql;port=3306;password=root;";

 MySqlConnection connect = new MySqlConnection(sqlconst);
 connect.Open();

 Console.WriteLine("成功链接mysql...");

MySqlCommand command = new MySqlCommand("create database if not exists testtesttest", connect);
            try
            {
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine("增加数据库失败..." + ex.ToString());
            }

connect.Close();

------------------------------------------------------------------------------检测创建------------------------------------------------------------------------------