public static void TestALTER() { MySqlTemplate.DROP("Test1"); CreateTableElement ct = new CreateTableElement("Test1"); ct.Add("ID", DataType.INT, true); ct.Add("Name", DataType.CHAR10, true); ct.Add("Age", DataType.INT); ct.Create(); MySqlTemplate.INSERT("Test1", new string[] { "ID", "Name", "Age" }, new object[] { 100, "张三", 16 }); MySqlTemplate.INSERT("Test1", new string[] { "ID", "Name", "Age" }, new object[] { 101, "王五", 17 }); MySqlTemplate.INSERT("Test1", new string[] { "ID", "Name", "Age" }, new object[] { 102, "李四", 18 }); MySqlTemplate.INSERT("Test1", new string[] { "ID", "Name", "Age" }, new object[] { 103, "赵六", 55 }); MySqlTemplate.ALTER("Test1", "Age", AlterType.DROP); string cmd = "SELECT * FROM Test1"; DataSet obj = MySqlHelper.GetDataSet(MySqlHelper.Conn, CommandType.Text, cmd, null); List <Test2> list = MySqlTemplate.IList <Test2>(obj); foreach (var item in list) { Console.WriteLine("ID:{0} Name:{1} Age:{2}", item.ID, item.Name, item.Age); } Console.WriteLine(); MySqlTemplate.ALTER("Test1", "Gold", AlterType.ADD, DataType.INT, "ID"); MySqlTemplate.UPDATE("Test1", new string[] { "Gold" }, new object[] { 2000 }); cmd = "SELECT * FROM Test1"; obj = MySqlHelper.GetDataSet(MySqlHelper.Conn, CommandType.Text, cmd, null); list = MySqlTemplate.IList <Test2>(obj); foreach (var item in list) { Console.WriteLine("ID:{0} Name:{1} Gold:{2}", item.ID, item.Name, item.Gold); } Console.WriteLine(); MySqlTemplate.ALTER("Test1", "Name", AlterType.MODIFY, DataType.VARCHAR40); MySqlTemplate.ALTER("Test1", "Name", AlterType.CHANGE, DataType.VARCHAR40, "Nickname"); MySqlTemplate.ALTER("Test1", "MyTest", AlterType.RENAME); }