/* * 按月新建数据表 * */ public function create_tables(){ //获取年月 $year_time = date('Ym'); $db = Db::connect('log'); Db::startTrans(); try { $sql = "CREATE TABLE `$year_time` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID', `api` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '请求API', `qs` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' COMMENT '参数', `time` int(10) UNSIGNED NOT NULL COMMENT '请求时间', `resp` json NOT NULL COMMENT '返回的JSON结果', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_request`(`api`, `qs`, `time`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '接口请求记录表' ROW_FORMAT = Dynamic;"; $db->query($sql); // 提交事务 Db::commit(); } catch (\Exception $e) { // 回滚事务 Db::rollback(); } }