mysql查询语句

1.根据name查询所有对应的pName并拼接在一起

SELECT
	id,
	name,
	GROUP_CONCAT(pName) AS pName
FROM
	testsql
GROUP BY
	name

2.多表联查出现多条重复数据进行去重

查询条件后跟上DISTINCT关键字

SELECT DISTINCT
	permission.id,
	permission.NAME,
	permission.uri 
FROM
	fr_admin admin,
	fr_admin_role adminRole,
	fr_role_permission rolePermission,
	fr_permission permission 
WHERE
	admin.id = adminRole.adnin_id 
	AND adminRole.role_id 
	AND rolePermission.permission_id = permission.id 
	AND admin.username = #{username}