revathskumar/addcolumn.sql

Created August 18, 2011 14:59

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/revathskumar/1154235.js"></script>
Save revathskumar/1154235 to your computer and use it in GitHub Desktop.

Download ZIP

Rename table and Column query

Raw

addcolumn.sql

ALTER TABLE `table_name` ADD `new_field` VARCHAR( 255 ) NOT NULL AFTER `after_this_field` 

Raw

renamecolumn.sql

ALTER TABLE `table_name` CHANGE  `old_field_name` `new_field_name` VARCHAR(100);

Raw

renametable.sql

RENAME TABLE `old_table_name` TO `new_table_name`;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment