Answers for "character set: 'utf8_unicode_ci'"

SQL
0

UTF8_UNICODE_CI

CREATE PROCEDURE randomizer()
BEGIN
  DECLARE i INT DEFAULT 0;
  DECLARE random CHAR(20) ;
  theloop: loop
    SET random = CONV(FLOOR(RAND() * 99999999999999), 20, 36);
    INSERT INTO test VALUES (i+1, random);
    SET i=i+1;
    IF i = 500000 THEN
      LEAVE theloop;
    END IF;
  END LOOP theloop;
END
Posted by: Guest on January-03-2021

Code answers related to "character set: 'utf8_unicode_ci'"

Code answers related to "SQL"

Browse Popular Code Answers by Language