1、创建表
CREATE TABLE `user_log` (
`device_id` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`app_id` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`times` int(100) DEFAULT NULL,
`duration` int(100) DEFAULT NULL,
`log_day` date DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
'''
字段及表说明:
表名:user_log
字段名:
log_day:登录日期
device_id:用户设备id
times:日登陆次数
duration:平均每次登陆时长
app_id:用户app的id,其中device_id和app_id确定唯一的用户
'''
2、插入数据
INSERT into user_log VALUES
('a001','R11',5,10,'2020/3/17'),
......
('a001','R11