Results 1 to 3 of 3

Thread: How do i?

  1. #1

    How do i?

    in mysql how do i do the following:
    change a collumn name?
    change a table name?
    thanks?

  2. #2
    Join Date
    Jul 2004
    Location
    Scotland, UK
    Posts
    81
    Changing a field name:
    changes `field` to `fields` (its a text field, null permitted - change the end part to suit).
    ALTER TABLE `table_name` CHANGE `field` `fields` TEXT DEFAULT NULL;

    Changing a table name:
    ALTER TABLE `table_name` RENAME `new_table_name`;

    Hope that helps
    Scott - My Spiel

  3. #3
    thanks and database name?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •