Mysql 基础专题

mysql 登录

--本地连接

mysql –uroot -p

--远程连接

mysql –uwgb –hXXX.XXX.XXX.XXX –p

mysql查询分析

MySQL_explain关键字分析查询语句 - 天使未必在场 - 博客园

mysql 运程访问

MySql Workbench -> GRANT ALL ON jihui88_mobile.* TO root@'192.168.0.102' IDENTIFIED BY '123456'

mysql 创建用户

create user 'root'@'localhost' identified by '你的密码';
grant all privileges on *.* to root@'localhost';

mysql 删除用户

drop user root@'%';

mysql 查询配置

show VARIABLES like '%max_allowed_packet%';

去除重复数据

select * from bind group by bind.layout_id 

 查询时间是最近的

SELECT agent_id as agentId,useable as useable FROM agent_account T WHERE ( add_time = (SELECT MAX (add_time) FROM agent_account WHERE agent_id IN(:ids) AND agent_id = T .agent_id))