https://blog.youkuaiyun.com/Hey_Linuxzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/Hey_Linux/article/details/41855741https://blog.youkuaiyun.com/Hey_Linux/article/details/41855741Hey_LinuxWed, 10 Dec 2014 23:33:34 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41833249https://blog.youkuaiyun.com/Hey_Linux/article/details/41833249Hey_LinuxTue, 09 Dec 2014 23:28:05 +0800 create index ind_company_na]]>https://blog.youkuaiyun.com/Hey_Linux/article/details/41810087https://blog.youkuaiyun.com/Hey_Linux/article/details/41810087Hey_LinuxMon, 08 Dec 2014 21:43:21 +0800 show [session | global] status; 注：session表示当前连接        global表示自数据库启动至今 eg：Mysql> show status;        Mysql> show global status;        Mysql> show stat]]>https://blog.youkuaiyun.com/Hey_Linux/article/details/41790887https://blog.youkuaiyun.com/Hey_Linux/article/details/41790887Hey_LinuxSun, 07 Dec 2014 21:08:15 +0800 create tables t2 like t1; Mysql> insert into t2 select * from t1;  2、mysql索引 a、Alert Table 用来创建普通索引、Unique唯一索引(当前列数值不可重复)或Primary Key 主键索引 Mysql> alter table table_name add ind]]>https://blog.youkuaiyun.com/Hey_Linux/article/details/41623997https://blog.youkuaiyun.com/Hey_Linux/article/details/41623997Hey_LinuxSun, 30 Nov 2014 16:46:40 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41596951https://blog.youkuaiyun.com/Hey_Linux/article/details/41596951Hey_LinuxSat, 29 Nov 2014 16:55:39 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41595525https://blog.youkuaiyun.com/Hey_Linux/article/details/41595525Hey_LinuxSat, 29 Nov 2014 14:25:51 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41595473https://blog.youkuaiyun.com/Hey_Linux/article/details/41595473Hey_LinuxSat, 29 Nov 2014 14:20:14 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41595159https://blog.youkuaiyun.com/Hey_Linux/article/details/41595159Hey_LinuxSat, 29 Nov 2014 13:37:30 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41594077https://blog.youkuaiyun.com/Hey_Linux/article/details/41594077Hey_LinuxSat, 29 Nov 2014 11:12:00 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41593935https://blog.youkuaiyun.com/Hey_Linux/article/details/41593935Hey_LinuxSat, 29 Nov 2014 10:58:50 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41593801https://blog.youkuaiyun.com/Hey_Linux/article/details/41593801Hey_LinuxSat, 29 Nov 2014 10:42:59 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41593429https://blog.youkuaiyun.com/Hey_Linux/article/details/41593429Hey_LinuxSat, 29 Nov 2014 10:04:14 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41593397https://blog.youkuaiyun.com/Hey_Linux/article/details/41593397Hey_LinuxSat, 29 Nov 2014 10:00:30 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41580775https://blog.youkuaiyun.com/Hey_Linux/article/details/41580775Hey_LinuxSat, 29 Nov 2014 00:06:39 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41577375https://blog.youkuaiyun.com/Hey_Linux/article/details/41577375Hey_LinuxFri, 28 Nov 2014 16:33:57 +0800https://blog.youkuaiyun.com/Hey_Linux/article/details/41555803https://blog.youkuaiyun.com/Hey_Linux/article/details/41555803Hey_LinuxThu, 27 Nov 2014 22:00:18 +0800grant all on *.* to user@10.10.0.1 indentified by ‘password’ (密码必须有引号) user账户只有备份权限 Mysql>grant replication slave on *.* to user@10.10.]]>