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 ...

There are times when you need to create a user only to have read and alter access to a database. The user can view,read and alter the data in the database but they cannot drop and create database ...

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 ...