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;
view employee_contact_info_view
as
select first_name, last_name, email, phone
from employees
order by last_name asc
with cascaded check option;
检查一下这样是否正常执行。