Error Code: 1630. FUNCTION rand. string does not exist, 1630rand. string
1. Error description
13:50:13call new_procedureError Code: 1630. FUNCTION rand.string does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual0.046 sec
2. Error cause
CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`()BEGIN set @a=101; while @a<2000 do set @b = rand.string(10); set @c=1; insert into example1 values(@a,@b,@c); set @a=@a+1; if(@a%2=0) then set @c=0; end if; end while;END
When assigning a value to @ B, @ B = rand. string (10) is used to write a random string stored procedure.
3. Solution
CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`()BEGIN set @a=101; while @a<2000 do set @b = rand_string(10); set @c=1; insert into example1 values(@a,@b,@c); set @a=@a+1; if(@a%2=0) then set @c=0; end if; end while;END