视图;
select * from TemArticle;
对视图进行增加数据
insert into TemArticle (type,author,au_id,articles,qq_group,fans...values('Linux','vivi',2019002,20,727998947,400);
insert into TemArticle (type,author,articles,qq_group,fans...)values('perl','vivi',23,727998947,50);
insert into TemArticle (type,author,articles,qq_group,fans)values...pytorch','vivi',25,727998947,50);
对视图进行删除数据
delete from viewname where...;
delete from TemArticle where fans...from viewname where...;
#查找TemArticle视图中文章数不小于50的信息
select ar_id,type,author,au_id,articles,qq_group,fans