Masao Kitamura

Home > MySQL > How To Add a MySQL Column with Index

How To Add a MySQL Column with Index

September 5th, 2009 Masao Leave a comment Go to comments

ALTER TABLE mytable
ADD mycolumn INT UNSIGNED NOT NULL AFTER othercolumn ,
ADD INDEX ( mycolumn );

Categories: MySQL Tags: common mysql