摘要:
1、查看表结构: desc 表名 2、多表查询 select * from a inner join b on a.id=b.id(内链接,只取交叉部分) select * from a left join b on a.id=b.id;(左外链接,左表取全部,右表取部分) select * fro 阅读全文
摘要:
语法 GRANT privileges [(columns)] ON DATABASE.TABLE TO 'username'@'hostname' [IDENTIFIED BY [PASSWORD] 'password'] [,'username'@'hostname' [IDENTIFIED B 阅读全文