Alter all tables

Samir
2014-04-19
2014-04-21
  • Samir
    Samir
    2014-04-19

    Hi

    I wonder how can I alter all tables of a database in one go using Adminer!

    Thanks in advance

     
  • Jakub Vrána
    Jakub Vrána
    2014-04-19

    What do you need to do? Adminer doesn't have any features to alter all tables at once.

     
  • Samir
    Samir
    2014-04-20

    Right. I need to change all the table collation from utf8_general_ci to utf8_unicode_ci. Is there any easy way to do this by using sql command instead of by going into each table and alter individually.

     
  • Jakub Vrána
    Jakub Vrána
    2014-04-21

    No.