201711122215->mysql增加database
来源:互联网 发布:sql基础教程第二版 pdf 编辑:程序博客网 时间:2024/06/05 20:36
目的:链接数据库实现库的新增
详细代码:
------------------------------------------------------------------------------直接创建------------------------------------------------------------------------------
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();
------------------------------------------------------------------------------检测创建------------------------------------------------------------------------------
- 201711122215->mysql增加database
- Oracle Database 11g RAC:增加节点
- Greepplum Database增加Segment Mirror全过程
- install mysql database
- mysql create database utf8
- MySQL database engines
- mysql的create database
- [Database]MySQL函数
- 【MySql-Command】-DataBase
- mysql employees sample database
- Check MySQL Database Size
- Check Mysql Database Size
- mysql语法database
- MySQL Database storage engine
- mysql --all-database
- MATLAB + DATABASE + MYSQL
- MySQL's Sample Database
- Recover Corrupt MySQL Database
- 再见软考
- Aerospike迁移--2
- win10 /Oracle VM VirtualBox 虚拟机ubuntu17.04 NAT host-only网络配置
- 流行排序和佩奇排序简述(manifold rank & Page rank)
- 轻松加精确完成水晶报表对象的对齐、移动及大小调整——使用准线设计
- 201711122215->mysql增加database
- jdk中的LinkedList的实现
- 设计模式-单例模式
- 设计模式,程序员的必经之路
- 菜狗的Python学习笔记 第三章 字符串的使用
- 从求素数开始
- CentOS 7.4使用Yum源安装MySQL 5.7.20
- 单向链表(C语言实现)学习记录
- 视频跟踪常用到的数据库