use corporate;alter
algorithm=merge
definer=current_user
sql security definer view employee_contact_info_view
('First Name', 'Last Name', 'Email Address', 'Telephone')
as
select first_name, last_name, email, phone
from employees
order by last_name asc
with cascaded check option;
为什么('First Name', 'Last Name', 'Email Address', 'Telephone')这句有错?
提示:Error Code: 1064. You have an error in your SQL syntax;
解决方案 »
- 如何建立数据库网站
- 【mysql问题】返回结果集存储在哪里????急急急~~~~~~~~~
- SQL语句求助
- insert into product_intro(belong) select belong from product where bigclassname=
- sql分页问题,
- linux下怎么开机启动mysql?
- 求救,PGSQL不支持UPDATE TAB SET C=(子查询) 怎么办
- 有没有办法可以把查询到的数据随机排列?
- 数据库在存储大段的文本好吗?
- 请问,像这种多条件查询的该怎么建立索引?
- 同样一条SQL语句,为什么在NAVICAT 和程序中结果却不一样呢?
- 新手求助:如何判断ABCD档,并送到指定的表中
view employee_contact_info_view
as
select first_name, last_name, email, phone
from employees
order by last_name asc
with cascaded check option;
检查一下这样是否正常执行。