How to split bigint from a comma seperated string

prabuddha posted 3 weeks ago in General

'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.