vs2010 ado 启动的时候创建数据表

        CString strSQL;
	strSQL.Format("CREATE TABLE IF NOT EXISTS bjyzj(id int(10) primary key auto_increment,address int(10) NOT NULL,remark varchar(255))");
	if (g_adoConnection->Execute(strSQL)==NULL)
	{
		OutputDebugString( "创建bjyzj失败\n" );
	}

删除表命令：

DROP TABLE table_name ;

参考：

https://www.runoob.com/mysql/mysql-drop-tables.html

https://www.runoob.com/mysql/mysql-drop-tables.html