MySQL Forums
Forum List  »  Views

Mysql Error on importing View
Posted by: Michael Russotti
Date: April 03, 2017 03:09AM

I'm having problems importing a mysql database. It is generating an error at create view.



Heres the query from the dump file

/*!50001 DROP TABLE `v_categories`*/;
/*!50001 DROP VIEW IF EXISTS `v_categories`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`DBUSERNAME`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_categories` AS select `C`.`categoryID` AS `categoryID`,`C`.`mainCategoryID` AS `mainCategoryID`,`C`.`categoryName` AS `categoryName`,`M`.`name` AS

`name`,`C`.`visible` AS `visible`,`M`.`priority` AS `main_priority`,`C`.`Priority` AS `priority` from (`categories` `C` join `categories_main` `M`) where (`M`.`id` =

`C`.`mainCategoryID`) */;

--

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql Error on importing View
1411
April 03, 2017 03:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.