MySQL Forums
Forum List  »  PHP

Aiuto view
Posted by: fra verde
Date: November 25, 2014 12:04PM

Ciao,
sto cercando di effettuare una vista su rsevenstpro in modo da poter visualizzare gli eventi su due siti differenti ma non capisco il perchè mi restituisce questo errore :
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS CREATE ALGORITHM=UNDEFINED DEFINED=`root`@`localhost` SQL SECURITY DEFINED VI' at line 4

La view in questione è :
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `clduc_rseventspro_tags` AS select `eventi`.`clduc_rseventspro_tags`.`id` AS `id`,`eventi`.`clduc_rseventspro_tags`.`name` AS `name`,`eventi`.`clduc_rseventspro_tags`.`publishe d` AS `published`,`eventi`.`clduc_rseventspro_tags`FROM `eventi`.`clduc_rseventspro_tags`;

Options: ReplyQuote


Subject
Written By
Posted
Aiuto view
November 25, 2014 12:04PM
November 25, 2014 01:11PM


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.