I'm trying to create a view in mySQL Query Browser. But when i create the view i get the following error,
"Definer is not fully qualified"
Here is the view itself,
CREATE VIEW `dzoic`.`POLLS_vwNumAnsPerQuestion` AS
COUNT(poll_answers.answer_id) AS NumAnswers,
INNER JOIN poll_questions ON poll_answers.question_id = poll_questions.question_id
Now i've played with it a little and when i add a definer (DEFINER = `dzoic`) i get the following error,
Script line: 1 Definer is not fully qualified
Script line: 1 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 'VIEW `dzoic`.`POLLS_vwNumAnsPerQuestion` AS
COUNT(poll_answers.an' at line 1
any help on this would be great. I'm lost as to why i'm getting this definer error.