CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1_users` AS select `users`.`id` AS `idUser`,`users`.`username` AS `username`,`users`.`idPrivilegio` AS `idPrivilegio`,`privilegios`.`privilegio` AS `privilegio`,`users`.`estado` AS `estado`,`users`.`nome` AS `nome`,`users`.`apelido` AS `apelido` from (`users` join `privilegios`) where (`users`.`idPrivilegio` = `privilegios`.`id`) ;
Sem comentários:
Enviar um comentário