Archive

Posts Tagged ‘common mysql’

How To Add a MySQL Column with Index

September 5th, 2009 Masao No comments

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

Categories: MySQL Tags: