Creation of a temporary copy of the table Doing the modification on the temporary copy Dropping the original table Renaming the copy to the original The whole time the above happens, the table is ...

Changing storage engine; rebuild table; change file_per_table, ALTER COLUMN OF TABLE, Change auto-increment value, Renaming a MySQL table, ALTER table add INDEX, Changing the type of a primary key ...

检查了后，发现表DAY_BOOK_REPORT确实不存在字段UNIT_PRICE_PCS，但是给表加字段时就报这个错误，遂咨询了一下他具体的操作过程 ...

Sometimes wee need to add a comment to a column for understanding purpose means to easily identify what is the use of that particular column. We can add comment to a column by two ways- at the time of ...