分类标签归档:mysql

join


  select user_basic.user_id,user_basic.mobile,user_relation.target_user_id 
  from user_basic join user_relation on user_basic.user_id=user_relation.user_id 
  where user_basic.mobile='13800001111';

Read more

我爱mysql


grant all on *.* to user@'1.1.1.1' identified by 'ZTZLlm';
grant all on db_name.* to user@'1.1.1.1' identified by 'e06AZr';

create user user@'127.0.0.1' identified by 'xxxxx';
grant all on *.* to user@'127.0.0.1';
grant select on *.* to user@&

Read more