我正在使用一个带有预准备语句的存储过程来从电子邮件地址字符串中查找行。它看起来是这样的:CREATE DEFINER=`root`@`localhost` PROCEDURE `get_users_by_email`(IN emailString VARCHAR(100)) SET @sql = CONCAT('SELECT user_id FROM users WHERE user_email IN (',emailString,
我有这个过程,但这会引发“未知列”错误。dsize INT DEFAULT 0; SELECT drive_size INTO dsize FROM profile WHEREusername = uname; UPDATE profile SET drive_size=new_size WHERE username= uname; DELIM