Is it possible to modify the SQL database with a script or do I need to edit it with "handles"?

Question

MySQL

Is it possible to write a SQL script that modifies the database. For example, does it remove certain columns, create indexes, make fields unique, etc.?

Answer 1

I understand you are looking for a teamALTER TABLE

Answer 2

It is the script that needs to be done. For then there is an opportunity to understand where you messed up. You can prepare everything in advance, without haste. When transferring by "handles", there is an option to forget to set grants, set an incorrect data type, and so on.