sprintf(sqlBuffer,"create table %s ( PacketNum int not null primary key,\
SecTime int not null,\
MsecTime int not null,\
IpPacketLen smallint not null,\
SourIp char(15) not null,\
DestIp char(15) not null,\
SourPort int not null,\
DestPort int not null,\
ProtocolType char(4) not null,\
IsUplinkData tinyint not null,\
SubProtocol smallint not null)",pTableName);
sprintf(sqlBuffer,"insert into %s values(%d,%d,%d,%d,'%s','%s',%d,%d,'%s',%d,%d)",
pTableName,
packetNum,
secTime,
usecTime,
ipDataLen,
pSourIP,
pDestIP,
sourPort,
destPort,
pProtocolType,
isUplinkData,
subProtocol);
sprintf(sqlBuffer,"update %s set SubProtocol=%d where PacketNum=%d",pTableName,subProtocol,packetNum);
sprintf(sqlBuffer,"drop table if exists %s",pTableName);