关于using 用法,在mysql中的使用 using表示两个表中相同字段查询操作 如:SELECT a . * , b . * FROM db_resources AS a LEFT JOIN db_news AS b using(user_name) LIMIT 0 , 30 相当于 SELECT a . * , b . * FROM db_resources AS a LEFT JOIN db_news AS b ON a.user_name = b.user_name LIMIT 0 , 30 的查询使用