collation request

samhill5215's profile image samhill5215 posted 1 month ago in General Permalink

Updating collations can be a time consuming and possibly error prone task, specially in databases with 20-plus tables. It would be awesome to be able to update collations at the three levels, database, table and column where a parent level updates the child level. The routine should also initially disable foreign key checking and re-enable it upon completion. phpMysql has one such routing but without foreign key disabling/enabling.

I may write such a routine myself but if it already exists please post it in the response. Heidi would ultimately become even better with its inclusion.

ansgar's profile image ansgar posted 1 month ago Permalink

That can already be achieved with the bulk table updater:

grafik.png

samhill5215's profile image samhill5215 posted 3 weeks ago Permalink

Awesome. Should have looked better. Thank you Ans.

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