rename

Rename a branch in SVN

If you made a typo or a similar mistake when naming your new branch, and you want to rename it, is very simple:

svn move http://svn.domain.com/project/branches/old/ http://svn.domain.com/project/branches/new

Remember to switch any working copies of the old branch though:

svn switch http://svn.domain.com/project/branches/new

 

MySQL Rename Field

To rename a field, there are loads of examples and different syntax on the web, so I thought I would blog the only one that works for me:

ALTER TABLE <table_name>
    CHANGE COLUMN <field_name> <new_field_name>;

I think you have to specify the field type even if you aren’t changing it.

ALTER TABLE clients
    CHANGE COLUMN telephone telephonenumber
    VARCHAR(40) DEFAULT NULL;