MYSQL: Add Column to Existing Table and Make it Auto Increment and Add Primary Key Constraint Link : Alter Table and Add Column
|
ALTER TABLE StudentPortalData ADD StudentPortalDataID INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (StudentPortalDataID); |
Query Plan and Query Profile for Executed Queries
|
USE SampleDatabase; SELECT @@profiling; SET profiling = 1; EXPLAIN SELECT * FROM SampleTable where DATE_OF_BIRTH='04131998' and CODE ='CODE'; SELECT * FROM SampleTable where DATE_OF_BIRTH='04131998' and CODE ='CODE'; SHOW PROFILES ; SHOW PROFILE FOR QUERY 15; |
TimeOut Error from MySQL WorkBench: Error Code:…