title: Split string in mysql inside procedure
body: <p>I have resumeids as string which i want to save in ResumeActivityLog table one by one row so total 6 rows.</p>
  <pre><code>var resumeids = &quot;R2W5D16T8BRYWZKRF28,RHL1B05ZTQ546JKF0RG,RD95SY747Z89M7GN8TP,R2N54T767CZTBY79N00,RHT2GR6K0FTYTPFG985,RDH4KV5Z3WX7SV2850N&quot;;
  </code></pre>
  <p>For this im using procedure SaveMultipleResumeActivityLog to save multiple enteries.
  How do i break this string of resumedid in single entry in every while loop iteration to generate 6 unique enteries.</p>
  <p><strong>SaveMultipleResumeActivityLog(resumeids, 6);</strong></p>
  <pre><code>CREATE  PROCEDURE `SaveMultipleResumeActivityLog`(
      _resumeDIDs           Text,
      _totalRecords          int(11),
  )
  BEGIN
      DECLARE i INT  DEFAULT 0;
      
      WHILE i &lt; _totalRecords DO 
      INSERT INTO `ResumeActivityLog`
      ( `ResumeDID`, `CreatedOn`)
      VALUES(resumeDID, NOW());
      SET i =i +1;
      ENDWHILE;
  END
  </code></pre>