mysqlpt-online-schema-change

Use pt-online-schema-change to add new column and populate it


I need to add a new column to existing MySQL table and populate with value calculated from another column. Is there a way to do this using pt-online-schema-change?

Thanks


Solution

  • pt-online-schema change runs ALTER TABLE statements, not UPDATE statements. If you need to populate a column you have two options: