在mysql中create view as 怎样写sql语句
答案:2 悬赏:70 手机版
解决时间 2021-11-17 00:51
- 提问者网友:我没有何以琛的痴心不悔
- 2021-11-16 05:35
在mysql中create view as 怎样写sql语句
最佳答案
- 五星知识达人网友:北城痞子
- 2021-11-16 06:13
-- 请修改 view_name 和 table_name 名称
create view view_name as
select * from table_name
create view view_name as
select * from table_name
全部回答
- 1楼网友:胯下狙击手
- 2021-11-16 07:20
几个简单的基本的sql语句
选择:select * from table1 where 范围
插入:insert into
table1(field1,field2) values(value1,value2)
删除:delete from table1 where 范围
更新:update table1 set field1=value1 where 范围
查找:select * from table1
where field1 like '%value1%' ---like的语法很精妙,查资料!
排序:select * from table1
order by field1,field2 [desc]
总数:select count as totalcount from table1
求和:select sum(field1) as sumvalue from table1
平均:select avg(field1) as
avgvalue from table1
最大:select max(field1) as maxvalue from table1
最小:select min(field1) as minvalue from table1
选择:select * from table1 where 范围
插入:insert into
table1(field1,field2) values(value1,value2)
删除:delete from table1 where 范围
更新:update table1 set field1=value1 where 范围
查找:select * from table1
where field1 like '%value1%' ---like的语法很精妙,查资料!
排序:select * from table1
order by field1,field2 [desc]
总数:select count as totalcount from table1
求和:select sum(field1) as sumvalue from table1
平均:select avg(field1) as
avgvalue from table1
最大:select max(field1) as maxvalue from table1
最小:select min(field1) as minvalue from table1
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯