devxlogo

October 4, 2018

Adding a New Column in a Specific Position

Consider the following table that already exists: CREATE TABLE ‘NUMBERS_TABLE’ (‘ONE’ INT(11) NULL DEFAULT NULL,’THREE’ INT(11) NULL DEFAULT NULL,’FIVE’ INT(11) NULL DEFAULT NULL)COLLATE=’utf8_bin’ENGINE=InnoDB; And we want to add a new