codice:
CREATE ALGORITHM = UNDEFINED DEFINER = `root` @ `localhost` SQL SECURITY DEFINER VIEW `conta` AS (

SELECT `richieste`.`idutente` AS `idutente` , count( `mia_tab`.`id_rq` ) AS `tot_rq` 
FROM `mia_tab` 
GROUP BY `richieste`.`idutente` 
)
sto importando un db mysql dentro phpmyadmin.

Ho un errore durante la creazione di una View:

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 'ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `conta' at line 1