weixin_44285972的博客

存过

column_comment 字段说明,column_type 字段类型,COLUMN_NAME 字段名,column_key 约束。

java执行sql ddl。

SQL语句的执行顺序：from-----where------group by------having ----select-----order by。SQL语句的编写顺序：select ----from---- where---- group by ----having ----order by。

linux mycat全局序列

linux mycat mysql 水平拆分——分表

linux mycat mysql 垂直拆分——分库

linux mycat 搭建双主双从读写分离

linux mysql搭建双主双从

mysql 搭建主从复制 报错：Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.具体原因：是因为两台服务器是克隆出来，uuid是一样的启动mysql,然后查询重启mysql......

linux mysql 配置一主一从

mysql查询某字段在哪个表中select table_schema,table_name from information_schema.columns where column_name = '字段名'table_schema 数据库名称table_name 表名column_name = ‘字段名’（要查询的列）

java批量插入数据1.封装jdbc工具类package com.vcredit.jdev.base.util;import java.io.InputStream;import java.sql.*;import java.util.Properties;public class JDBCUtils { /** * @return * @throws Exception * @Description 获取数据库的连接 */ pu

mysql 建表 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs；Row size too large. The maximum row size for the us

linux 安装mysql