CREATE TABLE firewallb
(idauto
int(11) unsigned NOT NULL AUTO_INCREMENT,dt
datetime DEFAULT NULL,dtstr
varchar(20) DEFAULT NULL,timeSeconds
int(11) DEFAULT NULL,priority
varchar(20) DEFAULT NULL,operation
varchar(20) DEFAULT NULL,messageCode
varchar(50) DEFAULT NULL,protocol
varchar(10) DEFAULT NULL,srcIp
varchar(20) DEFAULT NULL,destIp
varchar(20) DEFAULT NULL,srcIPNumber
bigint(20) DEFAULT NULL,destIPNumber
bigint(20) DEFAULT NULL,srcPort
int(11) DEFAULT NULL,destPort
int(11) DEFAULT NULL,destService
varchar(20) DEFAULT NULL,direction
varchar(20) DEFAULT NULL,flags
varchar(20) DEFAULT NULL,command
varchar(20) 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 fw_index_srcip
(srcIp
),
KEY fw_index_destip
(destIp
),
KEY fw_index_srcport
(srcPort
),
KEY fw_index_destport
(destPort
),
KEY fw_index_srcipnumber
(srcIPNumber
),
KEY fw_index_destipnumber
(destIPNumber
),
KEY fw_index_priority
(priority
),
KEY fw_index_dt
(dt
),
KEY fw_index_timeseconds
(timeSeconds
),
KEY fw_index_oper
(operation
),
KEY fw_index_slot5min
(slot5min
),
KEY fw_index_slot30min
(slot30min
),
KEY fw_index_slot1min
(slot1min
),
KEY fw_index_slot60min
(slot60min
)
) ENGINE=MyISAM AUTO_INCREMENT=16600932 DEFAULT CHARSET=utf8;
怎么转换为sql语句这是mysql
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
悬赏问题
- ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
- ¥15 如何在scanpy上做差异基因和通路富集?
- ¥20 关于#硬件工程#的问题,请各位专家解答!
- ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
- ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
- ¥30 截图中的mathematics程序转换成matlab
- ¥15 动力学代码报错,维度不匹配
- ¥15 Power query添加列问题
- ¥50 Kubernetes&Fission&Eleasticsearch
- ¥15 報錯:Person is not mapped,如何解決?