视图与索引

1.视图(view)
(1)创建视图:create view视图名
as
select*from基表名
where
group by
having
order by
limit
(2)修改视图:alter view视图名
as
select*from基表名
where
group by
having
order by
limit
(3)插入数据(插入基表):insert into视图名
values(……);
(4)修改数据(修改基表):update视图名set列表名
where
group by
having
order by
limit
注意事项：一次只能修改1个基表
(5)删除数据(删除基装):deletet from视图名
where
group by
having
order by
limit
注意事项：依赖多个基表时不能删除数据
(6)删除视图:drop view视图名
!-索引(index)
(1)创建:create index索引名
on基表名(列表名(参数))
(2)查看:show index from 基表名(\G)
(3)删除:drop indx索引名on基表名