Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Loop over all columns of a table

pablas's profile image pablas posted 4 weeks ago in General Permalink

I want to loop over all the columns of a few tables and run various SQL queries like the number of missing values, min, max, etc. and write results to a new table. However, I don't know how I can loop over all the columns of all the tables. Can you guide how I can write a procedure for that or any other way?

I have MariaDB 10.4 Series and Heidi SQL version 10.2.0.5599.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.