Reencode columns in table

With this simple tool, you can generate ALTER QUERYs to change the encoding of columns in a MySQL database table in bulk.

1.First, get the table structure in the MySQL console with the following command, where you insert the table name instead of table_name


desc table_name;

For more information, see the documentation for this command.

2.Paste the output of the command into the box below

3.Set the table name and the desired new encoding

4.Start ALTER QUERY generation with the following button

5.Copy the generated ALTER QUERY

helpdesk

we are ready to serve

currently online

agents online 2 / 6

Platon Technologies

How can we help you?

We accept reports of problems or other inducements related to the use of our products and services.

 

helpdesk@platon.net +421 222 111 321

In case you need any help, contact us by e-mail or by phone.

  • On the phone from 8:30 - 17:30
  • Sometimes even on weekends
  • Simple human approach
  • Complex problems solving
contact form

Give a chance to our online help-center. You can find there more than:

  • 6 categories
  • 58 manuals
  • 22 e-mail settings
  • 7 programming tips
go to counseling

Questions about our products or any specific request? Contact us.

Thanks for message

If necessary, we will contact you.

Send of message failed

Please contact us at helpdesk@platon.net.

NEWSLETTER

Subscribe to receive our news and current offers

Thanks for your subscribe

Subscribtion has failed