7.在视图V_addr中增加一条记录(内容如下),并查看members表中记录的改变情况;
‘fengf’,‘冯飞’,‘男’,‘1977-05-04’,‘天津市’,5500.0,‘ff0504’
如果不允许此条记录添加成功,需如何操作?
-- 3.在members表中创建地址为“湖南株洲”的会员的视图V_addr;
CREATE VIEW V_addr as SELECT * FROM members WHERE M_address='湖南株洲';
INSERT INTO v_addr (M_account, m_name, m_birth,m_sex, m_address, m_salary, m_password)
VALUES ('fengf', '冯飞', '1977-05-04', '男','天津', 5500.0, 'ff0504');
发现视图中没有插入,请问如何插入?