cxws110的博客

上述错误，是因为字符集的问题，解决方法就是在导入命令中加：--default-character-set=utf8

mysql -uroot -p -e"select doc_subject 文档标题, doc_expire_time 过期时间 from 表名 where doc_expire_time is not null order by doc_expire_time desc" > ./test.xls

mysql -h localhost -u 用户名 -p密码 //連接數據庫use desk_show; //使用數據庫show tables; //顯示數據表describe sys_att; //顯示表結構mysql其他命令：sho

进行mysql初始化时报错：mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory安装依赖：yum install -y libaioyum -y install numactl再初始化就OK了mysql -- initialize;...

springboot连接mysql时发生错误：java.sql.SQLException:Theservertimezonevalue'й׼ʱ'isunrecognizedorrepresentsmorethanonetimezone.YoumustconfigureeithertheserverorJDBCdriver(viathe'serverTimezone'configurationproperty)touseam...

打开mysql的命令窗口第一步，输入alter user 'root'@'localhost' identified with mysql_native_password by 'root的密码';第二步，输入flush privileges;这两步都提示 'OK'后就可以了