https://blog.youkuaiyun.com/hellosunqizh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/hellosunqi/article/details/79055383https://blog.youkuaiyun.com/hellosunqi/article/details/79055383hellosunqiSun, 14 Jan 2018 10:53:46 +0800 select concat('KILL ',id,';') from information_schema.processlist where user=’sam' into outfile '/tmp/a.txt 脚本内容如下： +------------------------+ | concat('KIL]]>https://blog.youkuaiyun.com/hellosunqi/article/details/70941754https://blog.youkuaiyun.com/hellosunqi/article/details/70941754hellosunqiFri, 28 Apr 2017 23:00:34 +0800 GRANT REPLICATION CLIENT ON *.*TO 'zabbix'@'%' IDENTIFIED BY ‘xxxxxxxx’; ERROR 1819 (HY000): Your password does notsatisfy]]>https://blog.youkuaiyun.com/hellosunqi/article/details/52527447https://blog.youkuaiyun.com/hellosunqi/article/details/52527447hellosunqiTue, 13 Sep 2016 16:54:11 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/51535948https://blog.youkuaiyun.com/hellosunqi/article/details/51535948hellosunqiMon, 30 May 2016 10:16:39 +0800 SHOW SLAVE STATUS\G; *************************** 1. row ***************************                Slave_IO_State: Waiting for master to send event                   Master_Host: 10.10.1]]>https://blog.youkuaiyun.com/hellosunqi/article/details/51306469https://blog.youkuaiyun.com/hellosunqi/article/details/51306469hellosunqiTue, 03 May 2016 17:47:59 +0800 show parameter compatible NAME                                 TYPE ------------------------------------ --------------------------------- VALUE ------------------------------ compatible]]>https://blog.youkuaiyun.com/hellosunqi/article/details/50973585https://blog.youkuaiyun.com/hellosunqi/article/details/50973585hellosunqiThu, 24 Mar 2016 17:42:29 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/49660989https://blog.youkuaiyun.com/hellosunqi/article/details/49660989hellosunqiThu, 05 Nov 2015 12:07:45 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/48268621https://blog.youkuaiyun.com/hellosunqi/article/details/48268621hellosunqiMon, 07 Sep 2015 17:11:48 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/47256399https://blog.youkuaiyun.com/hellosunqi/article/details/47256399hellosunqiMon, 03 Aug 2015 15:02:46 +0800 set linesize 1000 SQL> col index_name for a40 SQL> col COLUMN_NAME for a20 SQL> select index_name,COLUMN_NAME from dba_ind_c]]>https://blog.youkuaiyun.com/hellosunqi/article/details/46862915https://blog.youkuaiyun.com/hellosunqi/article/details/46862915hellosunqiMon, 13 Jul 2015 15:17:51 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/45056839https://blog.youkuaiyun.com/hellosunqi/article/details/45056839hellosunqiWed, 15 Apr 2015 11:30:09 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/43937205https://blog.youkuaiyun.com/hellosunqi/article/details/43937205hellosunqiWed, 25 Feb 2015 14:17:35 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/43608281https://blog.youkuaiyun.com/hellosunqi/article/details/43608281hellosunqiSat, 07 Feb 2015 20:11:03 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/42744393https://blog.youkuaiyun.com/hellosunqi/article/details/42744393hellosunqiThu, 15 Jan 2015 17:57:37 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/41314811https://blog.youkuaiyun.com/hellosunqi/article/details/41314811hellosunqiThu, 20 Nov 2014 16:05:20 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/41247391https://blog.youkuaiyun.com/hellosunqi/article/details/41247391hellosunqiTue, 18 Nov 2014 15:15:54 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/39077373https://blog.youkuaiyun.com/hellosunqi/article/details/39077373hellosunqiFri, 05 Sep 2014 10:13:33 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/39003697https://blog.youkuaiyun.com/hellosunqi/article/details/39003697hellosunqiTue, 02 Sep 2014 11:21:34 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/38845221https://blog.youkuaiyun.com/hellosunqi/article/details/38845221hellosunqiTue, 26 Aug 2014 11:24:39 +0800https://blog.youkuaiyun.com/hellosunqi/article/details/38843469https://blog.youkuaiyun.com/hellosunqi/article/details/38843469hellosunqiTue, 26 Aug 2014 09:56:17 +0800