How to modify fields online by mysql

This article mainly introduces mysql how to modify the field online, the article is very detailed, has a certain reference value, interested friends must read it!

You can modify the table structure online by using pt-online-schema-change

Pt-online-schema-change-- user=dba-- password=jsrh2sdshj-- host=192.168.27.21-- alter= "MODIFY COLUMN begin_date timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP" dazzling huisoumt blinds productsale-- execute

Pt-online-schema-change-- user=root-- password=cG3sBD9mazGI-- alter= "MODIFY COLUMN begin_date timestamp NOT NULL DEFAULT''ON UPDATE CURRENT_TIMESTAMP"-- execute Drunhuisou, execute Drunhuisou, tweets, blinds, products, sales

The above is all the content of the article "how to modify fields online by mysql". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!