How to insert email ID field with @ from a stored procedure in mysql? -
I have a basic mysql stored procedure for inserting user data with an email ID, for example
< Pre> call INSERTUSER ('any', 'someone@email.com');
My problem is that the stored procedure is taking @ as a special character. I'm new to mysql How can I insert it? Is there an escape character? help please.
call inseter ('any', 'someone \ @ email. Com');
Comments
Post a Comment