目的:同一个mysql数据库中,实现不同Schema下数据表的结构复制,以及数据的复制
之前在用Unity3d和mysql,这次直接就在脚本里实现了,unity里放一个按钮,按钮绑定脚本里的函数,函数如下
public void Copy()
{
string constr = "server = localhost; User Id = root; password = 123456";//呃连接字符串这点儿信息就够了
//建立连接的语句
MySqlConnection mycon = new MySqlConnection(constr); //建立连接
mycon.Open();
MySqlCommand mycmd = new MySqlCommand("create table new.stuinfo like old.stuinfo", mycon);
object count = mycmd.ExecuteScalar();//执行
}
接下来把数据也复制过去,整个代码改成这样
public void Copy()
{
string constr = "server = localhost; User Id = root; password = 123456";
MySqlConnection mycon = new MySqlConnection(constr);
mycon.Open();
//这里加了if not exists(SQL语法很重要)
MySqlCommand mycmd = new MySqlCommand("create table if not exists new.stuinfo like old.stuinfo", mycon);
object count = mycmd.ExecuteScalar();
//表结构有了,开始插入数据
MySqlCommand mycmd2 = new MySqlCommand("insert new.stuinfo select * from old.stuinfo", mycon);
mycmd2.ExecuteNonQuery();//这一句或者上面那句都可以执行command
}
SQL MYSQL这一块学的不系统,都是遇到问题找问题,现学现卖,有机会好好打下基础