luoganttcc

摘要： 1.添加PRIMARY KEY（主键索引） mysql>ALTER TABLE `table_name` ADD PRIMARY K... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(8) 评论(0) 推荐(0)

摘要： with f as ( select * from ( SELECT player_id , ... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(9) 评论(0) 推荐(0)

摘要： with f as ( select * from ( SELECT player_id , ... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(9) 评论(0) 推荐(0)

摘要：设置为120m mysql> set session bulk_insert_buffer_size = 1024 * 1024 *... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(16) 评论(0) 推荐(0)

摘要：设置为120m mysql> set session bulk_insert_buffer_size = 1024 * 1024 *... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(19) 评论(0) 推荐(0)

摘要：在建表的时候直接指定utf8,这样就读写中文就没有问题 create table player_info1 ( ... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(7) 评论(0) 推荐(0)

摘要：在建表的时候直接指定utf8,这样就读写中文就没有问题 create table player_info1 ( ... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(4) 评论(0) 推荐(0)

摘要： db.users.aggregate([{$group: {_id: '$name'} }]) 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(3) 评论(0) 推荐(0)

摘要： db.users.aggregate([{$group: {_id: '$name'} }]) 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(3) 评论(0) 推荐(0)

摘要： db.runCommand({ touch: 'snapshot', data: true, index: true}) ... 阅读全文

posted @ 2022-08-19 22:52 luoganttcc 阅读(3) 评论(0) 推荐(0)