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);
}
