mysql存储过程中字符串参数单引号

注意:存储过程中单引号  ,四个单引号

SET @sql = CONCAT('select user_id into ',m_user_id,' from go_user where mobile =','''',p_user_name,'''',' AND password=','''',p_password,'''');

 

posted @ 2014-12-20 11:23  飞剑  阅读(5064)  评论(0编辑  收藏  举报