Mysql创建视图时出现字段相同的冲突解决

由于product和repository两张表中有两个相同的字段 id 和 name，所以在创建视图时会出现 “duplicate column name id“ 的报错。

解决方法是对相同字段名字起一个别名即可。

SELECT
	`product`.`id` AS `pid`,
	`product`.`name` AS `pname`,
	`repository`.`id` AS `rid`,
	`repository`.`name` AS `rname`,
	`stock`.`amount` AS `amount`,
	`product`.`lower` AS `lower`,
	`product`.`upper` AS `upper` 
FROM
	(( `product` JOIN `repository` ) JOIN `stock` ) 
WHERE
	((
			`stock`.`pid` = `product`.`id` 
		) 
	AND ( `stock`.`rid` = `repository`.`id` ))