qq_36723759的博客

1、安装mysql 5.7 yum install mysql 2、运行mysql systemctl start mysqld 3、获取临时密码 cat /var/log/mysqld.log | grep temp 4、本地连接mysql mysql -u root -p 然后输入临时密码登录 5、修改密码 set password for 'root'@localhost = password("新密码") 6、增加远程连接授权 grant all privileges on *.* to

mysql 常用数学函数总结 1、abs( number )2、sign( number )3、mod( number1, number2 )4、round( number[, degree] )5、ceil( number )6、floor( number )7、truncate( number, degree)8、pow(x, y)9、sqrt( number )10、pi()11、rand(...

参考博客：https://www.cnblogs.com/geaozhang/p/6739303.html 常用字符串函数总结1、lower(column | str)2、upper(column | str)3、concat(column|str1, column|str2, ...)4、concat_ws(separator, str, str2,...)5、substr( str, pos[...