MySQL Forums :: Stored Procedures :: Stored procedure doesn't work correctly


Advanced Search

Re: Stored procedure doesn't work correctly
Posted by: Peter Brawley ()
Date: March 03, 2017 11:06PM

Pay attention to error messages. Of this cmd ...

set @st2 = CONCAT_WS('', 'GRANT SELECT ON', ' ','\'',`%`,'\'','.*', ' ', 'TO', ' ', @eid) ;

MySQL says: "Unknown column '%' in 'field list'".

What problem is putting this code in an sproc meant to solve?

Options: ReplyQuote


Subject Views Written By Posted
Stored procedure doesn't work correctly 647 Quazi Siddiqui 03/03/2017 09:22PM
Re: Stored procedure doesn't work correctly 65 Peter Brawley 03/03/2017 11:06PM
Re: Stored procedure doesn't work correctly 57 Quazi Siddiqui 03/03/2017 11:17PM
Re: Stored procedure doesn't work correctly 53 Peter Brawley 03/04/2017 12:59AM
Re: Stored procedure doesn't work correctly 58 Quazi Siddiqui 03/06/2017 10:33AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.