using System;
using System.Collections;
using System.Configuration;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data;
namespace Sql
//数据库简单测试
{
    class InsertSql1
    {
        public static void Main(string[] args)
        {
            string constr="server=localhost;User Id=root;password=219229;Database=reg";
            MySqlConnection mycon=new MySqlConnection(constr);
            mycon.Open();
            MySqlCommand mycmd = new MySqlCommand("insert into buyer(name,password,email) values('小王','dikd3939','[email protected]')",mycon);
            if (mycmd.ExecuteNonQuery()>0)
            {
                Console.WriteLine("数据插入成功！");
            }
            Console.ReadLine();
            mycon.Close();
        }
    }
}