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 Python时间序列如何拟合疏系数模型
- ¥15 求学软件的前人们指明方向🥺
- ¥50 如何增强飞上天的树莓派的热点信号强度,以使得笔记本可以在地面实现远程桌面连接
- ¥20 双层网络上信息-疾病传播
- ¥50 paddlepaddle pinn
- ¥20 idea运行测试代码报错问题
- ¥15 网络监控:网络故障告警通知
- ¥15 django项目运行报编码错误
- ¥15 STM32驱动继电器
- ¥15 Windows server update services