mysql数据库，如何创建删除修改查询一个视图view？

CREATE TABLE `pets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
INSERT INTO `pets` VALUES (1,'小黑',1),(2,'虎子',2),(3,'二赖子',2),(4,'老白',3),(5,'老许',3),(6,'小白',3);

CREATE TABLE `pets_category` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO `pets_category` VALUES (1,'大猫'),(2,'大狗'),(3,'小猫');

CREATE VIEW [视图名称] AS [SELECT语句];

CREATE VIEW view_pets as select id,name FROM pets;

CREATE VIEW view_pets2 as select a.id,a.name,a.cid,b.name as cname FROM pets as a left join pets_category as b using(cid);

CREATE VIEW view_pets3(pet_id,pet_name,pet_category_id,pet_category_name) as select a.id,a.name,a.cid,b.name as cname FROM pets as a left join pets_category as b using(cid);

DROP VIEW IF EXISTS [视图名称]

ALTER VIEW [视图名称] AS [SELECT语句]

ALTER VIEW view_pets as select id as pet_id,name FROM pets;