MySQL基本语句和连接字符串

需要先下载mysqlnet.exe,安装后引用CoreLab.MySql.dll

基本语句

insert into `mis`.`users`; ( name, age) values ( 'ywm', 13)

select id, name, age from `mis`.`users` limit 0, 50

delete from `mis`.`users` where id > 8

update `mis`.`users` set name = 'ywm1' where id = 13

连接字符串

MySqlConnection conn = new MySqlConnection('User Id=root;Password=sa;Host=localhost;Database=mis;');conn.Open();MySqlDataAdapter da = new MySqlDataAdapter('select id, name, age from `mis`.`users` ',conn);DataSet ds = new DataSet();da.Fill(ds,'users'); conn.Close();DataGrid1.DataSource= ds;DataGrid1.DataBind();