Sometimes we need to add a column after a particular column. We can do this easily by using ALTER command with AFTER attribute.
Example: in the below command I'm adding "latitude" column after "address" column where "address" column already exists in the "places" table.
ALTER TABLE `places` ADD COLUMN `latitude` VARCHAR(50) NULL AFTER `address` ;
Hope this will help you :)
0 Comment(s)