修改表结构添加字段
ALTER TABLE `device_record`
ADD COLUMN dev_seconds bigint(20) DEFAULT 0 AFTER `dev_info_new`;
ALTER TABLE `device_record`
ADD COLUMN dev_power varchar(10) DEFAULT NULL AFTER `dev_status`;
修改表结构删除字段
ALTER TABLE `device_record`
DROP COLUMN dev_secondss
查询数据去重
SELECT DISTINCT
dev_imei
FROM
device_record;
查询数据总数(去重)
SELECT
COUNT(DISTINCT dev_imei)
FROM
device_record;
清空表数据
DELETE
FROM
device_record;