Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


mysql error cant update table in stored function trigger because it is already


mysql error cant update table in stored function trigger because it is already  using -'php,mysql,triggers'

I am running a MySQL Query. But when a new row is added from form input I get this error:

Error: Can't update table 'brandnames' in stored function/trigger because it is
already used by statement which invoked this stored function/trigger.


From the code:

CREATE TRIGGER `capital` AFTER INSERT ON `brandnames`
FOR EACH
ROW UPDATE brandnames
SET bname = CONCAT( UCASE( LEFT( bname, 1 ) ) , LCASE( SUBSTRING( bname, 2 ) ) )


What does this error mean?
    

asked Sep 16, 2015 by sujata naik
0 votes
18 views



Related Hot Questions



Government Jobs Opening


...