How to split bigint from a comma seperated string

[expired user #11719]'s profile image [expired user #11719] posted 6 years ago in General Permalink

'700000013,700000039,700000047'

I need to split numbers from above string and need to put them in to a table column like;

  • ids
  • 700000013
  • 700000039
  • 700000047

length of the string can be variable (can be add more ids in defferent times. I can use a procedure for this.

I need the easiest way like using STRING_SPLIT ( string , separator ) . but this not working on heidiSQL.

How can I solve this?

Please login to leave a reply, or register at first.