Error Code: 1305. FUNCTION student. rand_string does not exist, randstring

Error Code: 1305. FUNCTION student. rand_string does not exist, randstring

1. Error description

13: 52: 42 call new_procedureError Code: 1305. FUNCTION student. rand_string does not exist0.000 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

In the 'new _ procedure 'stored procedure, you need to call the rand_string stored procedure, but the rand_string stored procedure is not written

3. Solution

Creates a rand_string stored procedure to generate random strings.