SELECT * FROM gps_gpsinfo t WHERE t.reportdate < TO_DATE('2019/4/28 10:05:07', 'yyyy-MM-dd hh24:mi:ss')
show VARIABLES like 'character%';
select VERSION();
set password for root@localhost = password('123');
SELECT * FROM gps_gpsinfo t WHERE t.reportdate < TO_DATE('2019/4/28 10:05:07', 'yyyy-MM-dd hh24:mi:ss')
show VARIABLES like 'character%';
select VERSION();
set password for root@localhost = password('123');
转载于:https://www.cnblogs.com/javazxy/p/10817877.html