CREATE TABLE netflowa
(idauto
int(11) unsigned NOT NULL AUTO_INCREMENT,TimeSeconds
int(11) DEFAULT NULL,parsedDate
datetime DEFAULT NULL,dateTimeStr
bigint(20) DEFAULT NULL,ipLayerProtocol
tinyint(2) DEFAULT NULL,ipLayerProtocolCode
varchar(10) DEFAULT NULL,firstSeenSrcIp
varchar(20) DEFAULT NULL,firstSeenDestIp
varchar(20) DEFAULT NULL,firstSeenSrcPort
int(5) DEFAULT NULL,firstSeenDestPort
int(5) DEFAULT NULL,moreFragments
tinyint(2) DEFAULT NULL,contFragments
tinyint(2) DEFAULT NULL,durationSeconds
smallint(5) DEFAULT NULL,firstSeenSrcPayloadBytes
int(11) DEFAULT NULL,firstSeenDestPayloadBytes
int(11) DEFAULT NULL,firstSeenSrcTotalBytes
int(11) DEFAULT NULL,firstSeenDestTotalBytes
int(11) DEFAULT NULL,firstSeenSrcPacketCount
int(11) DEFAULT NULL,firstSeenDestPacketCount
int(11) DEFAULT NULL,recordForceOut
tinyint(2) DEFAULT NULL,slot1min
int(11) DEFAULT NULL,slot5min
int(11) DEFAULT NULL,slot30min
int(11) DEFAULT NULL,slot60min
int(11) DEFAULT NULL,
PRIMARY KEY (idauto
),
KEY index_nfa_sip
(firstSeenSrcIp
),
KEY index_nfa_sport
(firstSeenSrcPort
),
KEY index_nfa_dip
(firstSeenDestIp
),
KEY index_nfa_dport
(firstSeenDestPort
),
KEY index_nfa_slot1min
(slot1min
),
KEY index_nfa_slot5min
(slot5min
),
KEY index_nfa_slot30min
(slot30min
),
KEY index_nfa_slot60min
(slot60min
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
http://blog.csdn.net/woshisap/article/details/7333893
基本语句格式差不多,http://database.51cto.com/art/201010/231018.htm
KEY index_nfa_sip (firstSeenSrcIp), KEY index_nfa_sport (firstSeenSrcPort), KEY index_nfa_dip (firstSeenDestIp), KEY index_nfa_dport (firstSeenDestPort), KEY index_nfa_slot1min (slot1min), KEY index_nfa_slot5min (slot5min), KEY index_nfa_slot30min (slot30min), KEY index_nfa_slot60min (slot60min)是什么意思
这些应该是索引,sqlserver创建索引语句http://blog.csdn.net/a9529lty/article/details/6082112
sqlserver的建表语句可能不需要这个,那个PRIMARY KEY是主键
USE 库名称
create table 表名(
idauto int(11) NOT NULL primary key,
TimeSeconds int(11) DEFAULT NULL,
parsedDate datetime DEFAULT NULL,
dateTimeStr bigint(20) DEFAULT NULL,
ipLayerProtocol tinyint(2) DEFAULT NULL,
ipLayerProtocolCode varchar(10) DEFAULT NULL,
firstSeenSrcIp varchar(20) DEFAULT NULL,
firstSeenDestIp varchar(20) DEFAULT NULL,
firstSeenSrcPort int(5) DEFAULT NULL,
firstSeenDestPort int(5) DEFAULT NULL,
moreFragments tinyint(2) DEFAULT NULL,
contFragments tinyint(2) DEFAULT NULL,
durationSeconds smallint(5) DEFAULT NULL,
firstSeenSrcPayloadBytes int(11) DEFAULT NULL,
firstSeenDestPayloadBytes int(11) DEFAULT NULL,
firstSeenSrcTotalBytes int(11) DEFAULT NULL,
firstSeenDestTotalBytes int(11) DEFAULT NULL,
firstSeenSrcPacketCount int(11) DEFAULT NULL,
firstSeenDestPacketCount int(11) DEFAULT NULL,
recordForceOut tinyint(2) DEFAULT NULL,
slot1min int(11) DEFAULT NULL,
slot5min int(11) DEFAULT NULL,
slot30min int(11) DEFAULT NULL,
slot60min int(11) DEFAULT NULL,
)
你试试
如果有错把数据类型改一改