mysql - View and table in same name is it possible -


is possible create mysql view , table in same name

for example have table hs_hr_employee want create view same name

create view hs_hr_employee select * hs_hr_employee; 

i m getting following error

#1050 - table 'hs_hr_employee' exists 

any thankful

regards

you can't , give view different name like

hs_hr_employee_view 

from manual

within database, base tables , views share same namespace, base table , view cannot have same name.


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -