mysql 深入学习一 数据结构导图

⛳Docker安装MySQL......

[mysql@node01~]$mysql-uroot-pabcd.1234-hnode01-Dtpcc10(root@node01)>selectcount(*)fromcustomer;+----------+|count(*)|+----------+|300000|+----------+1rowinset(0.06sec)(root@node01)>select@@global.secure_file_priv;......

在线开启GTID复制(root@node01)>setglobalenforce_gtid_consistency=warn;QueryOK,0rowsaffected(0.04sec)(root@node02)>setglobalenforce_gtid_consistency=warn;QueryOK,0rowsaffected(0.07sec)(root@node01)>setglobalenf......

[mysql@node01~]#uuidgen8d1945a5-5c74-4ba0-8240-e9d731110753[mysql@node01~]$vim/etc/my.cnfserver_id=101log_bin=mysql-binbinlog_cache_size=16Mmax_binlog_size=128M......

一、安装yum仓库rpm-ivhhttps://dev.mysql.com/get/mysql80-community-release-el8-8.noarch.rpm二、先禁用本地的MySQL模块yummodule-ydisablemysqlMySQL8.0CommunityServer......

mysql常用脚本语法创建表：CREATETABLEtest_db1.test_table1(idINTauto_incrementNOTNULL,my_namevarchar(100)NOTNULL,memovarchar(100)NULL,CONSTRAINTtest_table1_PKPRIMARYKEY(id))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COLLATE=ut......

(root@node01)>createuser'donor'@'%'identifiedby'donor';QueryOK,0rowsaffected(0.10sec)(root@node01)>grantbackup_adminon*.*to'donor'@'%';QueryOK,0rowsaffected(0.23sec)(r......

updaterailwayrjoinrailway_sectionrsonr.id=rs.railway_idjoinwork_stationwsonr.id=ws.railway_idjoinpatrollerponr.id=p.railway_idsetrs.railway_name=#{name},ws.railway_name=#{na......

转储数据库mysqlpump-uroot-p--all-databases>full.sqlmysqlpump-uroot-p--all-databases--exclude-databases=soe>full.sqlmysqlpump-uroot-p--databasestpcc10>tpcc10.sqlmysqlpump-uroot-p--parallel-schemas=4:tpcc10>tpcc10.sql......

摘要本文详细记录了Linux下MySQL5.7的安装步骤，基于CentOS7.2与中标麒麟7两个版本的操作系统下的实践总结而成（大多数图片截取自中标麒麟7）。引子我所在的人力资源和社会保障行业线，项目的业务数据库绝大多数是Oracle，其实很少见到MySQL。近几年有从Oracle向国产数据库（OceanBase、达......