Mysql

控制台报错如下 Wed Apr 10 17:59:18 CST 2019 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. ...

mysqldump 导入导出 到出 mysqldump --column-statistics=0 -uroot -hmsite-server.wonderlandnet.cn -psckj123456 prj_shangye_new_test > C:\Users\DELL\Desktop\md\db\test.sql -- 线上 mysqldump --column-statistics=0 -usysa -hrm-bp11j9r390x32c307o.mysql.rds.aliyuncs.com -pSckj@123456 prj_shangye_new > C:\Users\DELL\Desktop\md\db\test_online.sql 解释： --column-statistics=0 因为新版的mysqldump默认启用了一个新标志，通过- -column-statistics=0来禁用他 -u用户名 -h 地址 -p 密码 数据库 > 目标地址 导入 mysql -uroot -proot -h127.0.0.1 -P3306 表名<C:\Users\DELL\Desktop\md\db\test.sql -- 线上 mysql -uroot -proot -h127.0.0.1 -P3306 shangye_test<C:\Users\DELL\Desktop\md\db\test_online.sql mysql -uroot -psckj123456 -hmsite-server.wonderlandnet.cn -P3306 prj_shangye_new_dev<C:\Users\DELL\Desktop\md\db\test.sql、 ...

windows下服务启动 net start mysql

Msql的sql_mode修改 问题复现 今天突然发现MySQL服务器升级之后sql_mode变成宽松摸索了，危害如下： 临时解决 set global sql_mode='strict_trans_tables'（阿里服务器默认是：strict_trans_tables） ...

-- 查询字节，字符长度 select length(orderBillId),char_length(orderBillId) from tb_order_nc_history where id = 108