1、创建视图
CREATE VIEW v as SELECT `code`, COUNT(`code`) as num FROM seaport GROUP BY `code`;
2、使用视图
SELECT * FROM v WHERE num>1;
1、创建视图
CREATE VIEW v as SELECT `code`, COUNT(`code`) as num FROM seaport GROUP BY `code`;
2、使用视图
SELECT * FROM v WHERE num>1;