Home > Database > Mysql Tutorial > mysql中创建视图时视图的名称对数据有影响?!?

mysql中创建视图时视图的名称对数据有影响?!?

WBOY
Release: 2016-06-06 09:37:01
Original
1044 people have browsed it

mysql视图数据数据库

这学期刚刚学数据库,关于mysql创建视图的问题
创建视图的语句:
create view supply(sno, pno, qty) as select spj.sno, spj.pno, spj.qty from spj, j where j.jno = spj.jno and j.jname = '三建';
这样视图创建成功,但是select * from supply;时查询结果是空empty set。
如果将视图名由supply改为其他的比如san_jian ,查询结果就就正确。求教,这是为什么?

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template