Update Statement in mysql procedure in not working

Question

Here is my procedure code. I am trying to update Username by putting old username in where clause.but it doesn't work.

 DELIMITER $$

    DROP PROCEDURE IF EXISTS `databasename`.`UpdateUsername` $$

    CREATE DEFINER=`root`@`localhost` PROCEDURE `UpdateUsername`
(IN  uname   VARCHAR(30),tid  VARCHAR(100),username VARCHAR(30)  )

BEGIN



UPDATE table_name SET Username=username WHERE Username=uname;

END $$ 
DELIMITER ;

please help me to FIX this problem.

no errors found ,doesnt update the value. – naveed Jan 31 '13 at 10:15 — naveed, Jan 31 '13 at 10:15
Mahmoud Gamal yes not its working.. – naveed Jan 31 '13 at 10:21 — naveed, Jan 31 '13 at 10:21
instead of comment answer me i ll accept it..Thanks a lot – naveed Jan 31 '13 at 10:22 — naveed, Jan 31 '13 at 10:22

score 3 · Accepted Answer · answered Jan 31 '13 at 11:07

3

Try to remove 'username' from line number '6' and use some other parameter name. It might be conflicting with your table Username field. For example: UPDATE table_name SET Username=OTHER_PARAMETER_NAME WHERE Username=uname;

answered Jan 31 '13 at 11:07

shabbir.rang

279
2
4
24

score 1 · Answer 2 · answered May 27 '13 at 13:34

Hi i have faced same issue give an alise to table name and try running update query

try this query

UPDATE table_name  tn SET tn.Username=username WHERE tn.Username=uname;

the query i have used is :

update file_structure fs set fs.active_status = 'N' where fs.fileid = temp_fileid and fs.appid = temp_appid;

score 0 · Answer 3 · answered Jan 31 '13 at 10:42

0

If tid is the table name, shouldn't you use tid instead of table_name in the update query?

answered Jan 31 '13 at 10:42

Rembunator

1,305
7
13

"tid" is another column name its not table_name. – naveed Jan 31 '13 at 11:00

Update Statement in mysql procedure in not working

3 Answers3