lctmei的博客

一、数据库链接 github.com/jinzhu/gormpackage utilsimport ( "fmt" _ "github.com/go-sql-driver/mysql" "github.com/jinzhu/gorm")type mysqlModel struct { Host string `yaml:"host"` Port int `yaml:"port"` User string `y.

OPTIMIZE TABLE my_table_name;

1、先创建子表，再创建总表DROP TABLE IF EXISTS `admin_log0`;CREATE TABLE `admin_log0` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `name` char(20) NOT NULL DEFAULT '' COMMENT '名字',  PRIMARY KEY (`id`)...

1、RANGE分区a.创建表DROP TABLE IF EXISTS `admin_log`;CREATE TABLE `admin_log` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `name` CHAR(20) NOT NULL DEFAULT '' COMMENT '名字',  PRIMARY KEY (`id`)...

1、查询test数据库表引擎是Innodb的表select table_catalog,table_schema,table_name,enginefrom information_schema.tableswhere table_schema='test' and engine='Innodb';select table_catalog ,table_schema...

一次mysql启动失败记录错误日志如下：[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist...

下载地址https://github.com/flike/kingshardInstall1. Install Go2. git clone https://github.com/flike/kingshard.git src/github.com/flike/kingshard3. cd src/github.com/flike/kingshard#(进入go目录下的src目录...

一、创建表 admin_an----day,os,uid,os_version在表中保持唯一DROP TABLE IF EXISTS `admin_an`;CREATE TABLE IF NOT EXISTS admin_an(  uid int unsigned NOT NUll DEFAULT '0' COMMENT '用户id',  os VARCHAR (20) NOT NU...