routines not working in local machine

Question

Hi this is my routine in mysqls it working in server but not working in local machine..

CREATE DEFINER=`root`@`localhost` PROCEDURE `ClassWise_Progress`(IN CLS INT, IN EXM INT)
BEGIN


  // some stuff

END

1) The error message seems extremely clear, 2) you're even linking to an answer which solves the problem! What's wrong?! — deceze, Dec 09 '13 at 11:05

score 1 · Accepted Answer · answered Dec 09 '13 at 11:10

1

You are using the backtick sign ` as a delimiter, which is used in MySQL to denote names of fields, tables an such. Change it to a single quote ':

CREATE DEFINER='root'@'localhost' PROCEDURE 'ClassWise_Progress' (IN CLS INT, IN EXM INT)

This way MySQL should interpret the strings correctly.

answered Dec 09 '13 at 11:10

Gerald Schneider

still same problem @Gerald Schneider – Surendra Dec 09 '13 at 11:23
well, have you checked if the user exists? – Gerald Schneider Dec 09 '13 at 11:26
ya,in same db some of routines working fine in local and server but this one not working in local i don't know what i am doing wrong in this? – Surendra Dec 09 '13 at 11:29
Hi frnd my problem is solved. Hello @Gerald Schneider using the backtick sign ` is not a problem we can use that sign if we use a single quote its throw a error. – Surendra Dec 10 '13 at 06:12

1 Answers1