Create View question

ironCode · #1 (**permalink**) 10-30-06, 17:01

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,

Code:

CREATE VIEW `dzoic`.`POLLS_vwNumAnsPerQuestion` AS
  SELECT
    COUNT(poll_answers.answer_id) AS NumAnswers,
    poll_questions.question_id
  FROM
    poll_answers
      INNER JOIN poll_questions ON poll_answers.question_id = poll_questions.question_id
  GROUP BY
    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,

Code:

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
  SELECT
    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.

Thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech