SELECT * FROM web_attack_ip WHERE UNIX_TIMESTAMP(attack_time) BETWEEN UNIX_TIMESTAMP('2017-08-10 14:48:29') AND UNIX_TIMESTAMP('2017-08-12 14:48:29') LIMIT 100;
问题描述依据datetime时间格式筛选。解决方案格式转换SELECT FROM_UNIXTIME(1563255818,"%Y-%m-%d %H:%i:%s") as time;datetimeSELECT * FROM web_attack_ip WHERE UNIX_TIMESTAMP(attack_time) BETWEEN UNIX_TIMESTAMP('2...