How To Add a MySQL Column with Index
September 5th, 2009
No comments
ALTER TABLE mytable
ADD mycolumn INT UNSIGNED NOT NULL AFTER othercolumn ,
ADD INDEX ( mycolumn );
ALTER TABLE mytable
ADD mycolumn INT UNSIGNED NOT NULL AFTER othercolumn ,
ADD INDEX ( mycolumn );
Recent Comments