Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

How to split bigint from a comma seperated string

prabuddha's profile image prabuddha posted 10 months ago in General


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.