在mysql进行操作时候遇到的一些问题 Last_IO_Errno: 1593 Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different fo...
mysql
MYSQL 常见命令行
一机多实例下直接cd到目录这不需要跟端口 Mysql -h host -u root -p pwd -P3306 mysqldamdin shutdown mysqldadmin start show databases; create database dbXXX; use dbxxx; show tables; show columns fro...
修改mysql5.6默认字符集为utf8
注:最好在mysqld下面就添加,不要写到最后免去,有可能会出错,完了记得重启 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci
mycat 笔记
mycat 启动 连接 mysql -umycat -pmycat -P8066 -h127.0.0.1 -Dmycat 记得加-h127.0.0.1 druidparser 1 8066 9066 mycat mycat true/false 如果出现乱码添加字符集 ...
error connecting: Timeout expired.错误原因
error connecting: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max po...
mysql命令:删除/替换 字段中包含的字符
删除数据库中某个字段中某个数据语法:replace(字段,字符1,字符2)解释如下:replace是替换语法字段:数据库中的某个字段,一般是你需要字段字符1:原字符,你需要替换的字符,比如A(示例学生)字符2:新字符,替...