sql
camma
这个作者很懒,什么都没留下…
展开
-
mysql表百万数据搜索性能测试
mysql、分区原创 2022-08-29 11:08:55 · 1056 阅读 · 0 评论 -
DBeaver连接时报错:Public Key Retrieval is not allowed
mysql原创 2022-08-29 10:31:06 · 396 阅读 · 0 评论 -
mysql复制数据库表到另一个表中
mysql原创 2022-08-29 10:25:52 · 1072 阅读 · 0 评论 -
mysql外部访问
use mysqlupdate user set host='%' where user = 'root'flush privilages;参考:https://www.cnblogs.com/ningy1009/p/12806748.html原创 2021-12-27 21:00:19 · 522 阅读 · 0 评论 -
mysql修改排序规则
alter table chrdbsnpnonegt convert to character set utf8mb4 collate utf8mb4_general_ci;参考:https://www.iludou.com/it/54512原创 2021-12-27 20:44:25 · 946 阅读 · 0 评论 -
mysql主键有Duplicate entry
mysql设置主键要求字段值唯一,但如果字段值不唯一,且要求检索速度快,建议设置indexmysql index:https://dev.mysql.com/doc/refman/8.0/en/create-index.htmlCREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_opti原创 2021-12-21 12:01:24 · 619 阅读 · 0 评论 -
mysql 根据相同字段将A表多条数据=修改到B表
ped表:umap表:问题:根据两表相同字段Individual ID,将ped表的Population字段对应到UMAP表的Population字段。解决:update umap,ped set umap.Population = ped.Population where umap.`Individual ID` = ped.`Individual ID`;参考:https://blog.csdn.net/qq_39313596/article/details/107107724..原创 2021-12-18 21:25:27 · 964 阅读 · 0 评论 -
java.sql.SQLException:The server time zone value xxx is unrecognized
https://blog.csdn.net/weixin_44505194/article/details/106674103原创 2021-12-14 08:16:56 · 236 阅读 · 0 评论 -
tsv文件导入mysql
LOAD DATA LOCAL INFILE 'filepath/filename.tsv' INTO TABLE DatabaseName.TableName;前提是保证mysql安装正确,并且已经创建了数据库DatabaseName以及对应的表TableName,并且根据.tsv文件的内容插入字段。如果还出现错误,则set global local_infile=on;参考:https://blog.csdn.net/qq_30071895/article/details/816276.原创 2021-12-10 21:32:57 · 1691 阅读 · 0 评论 -
sql统计相同数据个数,并封装成map
select `Superpopulation code`,count(*) from samples group by `Superpopulation code`;DAO层:@Select("select `Population code` as populationCode,count(*) from samples group by `Population code`") List<Map<String, Integer>> countPopulation(.原创 2021-12-10 21:27:58 · 302 阅读 · 0 评论 -
mybatis逻辑删除
先配置yml:mybatis-plus: global-config: db-config: logic-delete-field: flag # 全局逻辑删除的实体字段名(since 3.3.0,配置后可以忽略不配置步骤2) logic-delete-value: 1 # 逻辑已删除值(默认为 1) logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)实体类字段上加上@TableLogic注解(可自定义规则):/**原创 2021-09-13 10:50:18 · 539 阅读 · 0 评论