MySQL Stored procedure – Split Delimited string into Rows
Kedar
This procedure will split a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And…
Browsing Tag
string to rows
1 post
32 responses to “MySQL Stored procedure – Split Delimited string into Rows”
thanks for the procedure it worked for me
Good code! Very elegant and easy to use.
I thanks a lot for your code, works perfect.
Thank you very much, it was of great help 🙂
HI
I have ran your code in my environment but when i try to call the sp it showing #1305 – PROCEDURE split_string does not exist.
Can you please help me on this
Since you are dealing with strings, I would use CHAR_LENGTH() instead of LENGTH() to also serve multi-byte characters. Otherwise your procedure can mess up the string lengths of various languages with special characters.
i want to split the string include the delimiter how to help can anyone suggest the query