How to use prepared statement with cursor in mysql?

Post By:user_69930 | Reply

When I executed this procedure by using "call update_city_category('gold');" , I got an error "table tb doesn't exist". So I guess I need to use prepared statement? But how should I use prepared statement in this stored procedure?

please help.

Thanks.

 

I didn't find the right solution from the internet.

 


`Reply Or Comment!
Please LogIn to Reply!