Can you really produce a mysql view and table in same title
for instance i've got a table hs_hr_worker i would like produce a view like a same title
create VIEW hs_hr_employee AS SELECT * from hs_hr_employee;
I m getting following error
#1050 - Table 'hs_hr_employee' already exists
Any help Grateful
you cannot , share with view different title like
Inside a database, base tables and sights share exactly the same namespace, so basics table along with a view cannot have a similar title.