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

Sometimes we need to drop a column that we don't need further from the table. We can do this by using DROP keyword with ALTER command. Syntax: To drop/delete the column from a table, use the following ...