MySQL performance tuning (iv) Quick Change table structure

1. Modifying the varchar type

To meet the requirements, the varchar (6) is now converted to varchar (8). The better approach is not to use altertable modify, but instead take the following steps:

A Create a temporary table and set the varchar to varchar (8) as follows:

B. Replace the. FRM table structure file

C. Then check it out.

Under Windows to test.

You can also refer to the article:

Http://blog.chinaunix.net/uid-77311-id-4440792.html

MySQL performance tuning (iv) Quick Change table structure