http://www.thelinuxwiki.com/index.php?action=history&feed=atom&title=Howto_alter_existing_mysql_tableHowto alter existing mysql table - Revision history2026-04-29T05:06:40ZRevision history for this page on the wikiMediaWiki 1.21.5http://www.thelinuxwiki.com/index.php?title=Howto_alter_existing_mysql_table&diff=179&oldid=prevNighthawk: Pushed from Themanclub.2013-04-12T15:45:20Z<p>Pushed from Themanclub.</p>
<p><b>New page</b></p><div>'''commands run from mysql interactive prompt'''<br />
<br />
Add new varchar column to the end of the table<br />
>ALTER TABLE `tablename_here` ADD `new_column_name` VARCHAR( 255 ) NOT NULL ;<br />
<br />
Add new integer column after an existing column in table<br />
>ALTER TABLE `tablename_here` ADD `new_column_name` INT NOT NULL AFTER `existing_column` ;<br />
<br />
This changes the column called "name" on the table called "people" to now allow 35 characters.<br />
>alter table people modify name VARCHAR(35) ; <br />
<br />
This removes the column "flavor" from the table called "icecream".<br />
>alter table icecream drop column flavor; <br />
<br />
<br />
<br />
[[category:mysql]]</div>Nighthawk