[email]soup_or_power[/email] (soup_or_power) wrote:
: I have some views whose identifier is same as that of table. I am
: unable to import the data with
: the command
: mysql -uuser -ppassword dbname < mydump.sql
: Can anyone suggest a fix without having to rename each view?
: ps: why did the mysql allow view and table to have the same identifier
According to the MySQL 5.0 Reference Manual :
"...a database cannot contain a base table and a view that have
the same name."
How did you get a view and a table with the same name?