wzj_wp的博客

转载地址：https://zhuanlan.zhihu.com/p/23624390

my.cnf 文件配置切换mysql管理用户vi /etc/my.cnf [mysqld]之后添加如下内容[mysqld]init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=...

1.cd /usr/local2.tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz[root@hadoop001 local]# lltotal 304468drwxr-xr-x. 2 root root 6 Nov 5 2016 bindrwxr-xr-x. 2 root root 6 Nov...

MySQL获取当前时间+时间：now(),sysdate()now()在执行开始就获取到时间，sysdate()动态的获取时间获取当前日期：curdate()获取当前时间：curtime()季度：quarter(date)年：year(date),月：month(date),日：day(date),周：week(date)一周第几天：dayofweek(date)1为星期...

SQL> select session_id from v$locked_object;SESSION_ID---------- 542 1014SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 542; SID SERIAL# USERN...