您的当前位置：首页正文

mysql数据库查询常用

来源：步旅网

USE tl_gamedb;

查询 role_id(角色id)和account_name（帐号）之间的关系

SELECT * FROM role_data WHERE role_id='248';
SELECT * FROM account_common WHERE account_name='test214';
SELECT * FROM role_data WHERE account_id='1752';

查询物品

SELECT * FROM item WHERE SERIAL='500000016920';
SELECT * FROM equip WHERE SERIAL='500000016920';

授权

create user 'root' @'192.168.1.%' identified by '123456'; 
grant all privileges on *.* to root@'%' identified by '123456'; flush PRIVILEGES; 
SELECT * from mysql.user; grant all privileges on *.* to root@'192.168.1.%' identified by '123456';

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文