[手游项目2]-13-mysql代码自动建表

自动创建表
static std::string m_SqlTable = "create table if not exists log_counter_%d(\
`Id` int(11) NOT NULL AUTO_INCREMENT,\
`ServerId` int(11) DEFAULT NULL,\
`nType` int(11) NOT NULL DEFAULT '0' COMMENT '日志类型',\
`nTime` varchar(255) DEFAULT '' COMMENT '插入时间',\
`nPlayerGUID` bigint(20) DEFAULT NULL COMMENT '玩家guid',\
`nParam1` int(11) DEFAULT '0',\
`nParam2` int(11) DEFAULT '0',\
`nParam3` int(11) DEFAULT '0',\
`nParam4` int(11) DEFAULT '0',\
`nParam5` int(11) DEFAULT '0',\
`sParam1` varchar(255) DEFAULT NULL,\
`sParam2` varchar(255) DEFAULT NULL,\
`sParam3` varchar(255) DEFAULT NULL,\
`sContent` text COMMENT '内容 json格式(扩展字段)',\
PRIMARY KEY (`Id`)\
			 );";

void Init()
{			 
	char buf[1024] = "";
	sprintf(buf, m_SqlTable.c_str(), nServerId);
#ifdef WIN32
	char name[2048] = {0};	
	Extralib::Text::ConvertToUtf8(buf, name);
	AddDbMsg(name);
#else
	AddDbMsg(buf);
#endif
}

Error=2013, Reason=Lost connection to MySQL server during query
https://www.cnblogs.com/zhuiluoyu/p/5953962.html