GitHub

alter-table.md

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

Day_03 - Auto Increment, Alter Table.sql

INSERT INTO pk_table VALUES(1000,'Ravi',37,'Bangalore','9876543212'); -- ERROR since custid 1000 is duplicate value INSERT INTO pk_table VALUES(1001,'Ravi',37 ...