mysql常用语句

create database name;/*创建数据库文件*/
show databases;
drop database name;
use name

c#中常用字符串:

using MySql.Data.MySqlClient;//引用mysql库

//创建MySqlConnection对象(链接库)
string connstr = "data 
//cs_test:数据库
source=localhost;database=cs_test;userid=root;password=123456;pooling=false;charset=utf8";//pooling代表是否使用连接池
MySqlConnection conn = new MySqlConnection(connstr);

//查找单个: ExecuteScalar()
返回值为查找到的元祖第一个属性，以object类型返回
string sql2 = "select names from characters where id=2";
MySqlCommand cmd2 = new MySqlCommand(sql2,conn);
conn.Open();
string names = cmd2.ExecuteScalar().ToString();
Console.WriteLine(names);
conn.Close();

//增、删、改: ExecuteNonQuery()
//返回值为int，不成功是0，成功是1
//characters 表名
string sql3 = "insert into characters (names,passwords) values ('XXX','1234456')";
MySqlCommand cmd3 = new MySqlCommand(sql3,conn);
conn.Open();
int s = cmd3.ExecuteNonQuery();
if (s == 0) 
Console.WriteLine("false");
else 
Console.WriteLine("success");
conn.Close();