Results 1 to 3 of 3

Thread: MySQL console - adding more fields to a table

  1. Sep 8th, 2005, 08:12 AM #1
    flukey2005
    flukey2005 is offline

    Thread Starter
    Member
    Join Date
    Apr 2005
    Posts
    51

    MySQL console - adding more fields to a table

    Hey guys,

    I do apologise if this is in the wrong place on the forum, wasn't sure where to put it.

    what i would liek to know is, how can i add more fields to a table that has already been created via the MySQL console.

    Cheers.

    Reply With Quote Reply With Quote
  2. Sep 8th, 2005, 08:26 AM #2
    john tindell
    john tindell is offline
    <?="Moderator"?> john tindell's Avatar
    Join Date
    Jan 2002
    Location
    Brighton, UK
    Posts
    1,099

    Re: MySQL console - adding more fields to a table

    You need to use ALTER. Eg
    Code:
    ALTER TABLE t2 ADD d TIMESTAMP;
    Heres the link for ALTER in the MySQL manual
    http://dev.mysql.com/doc/mysql/en/alter-table.html
    [MindlessAnt.co.uk] [MSDN] [Paging Records With MS SQL] [Virtual CD-ROM Drive From Images] [WorldOverRide.co.uk] [Create PDF's using pure PHP] [PHP.net Search Bars]
    [PHP: Check Password Strength][PHP: BB Code] [PHP: Date Select]

    If you Question has been answered please mark the thread as [RESOLVED]
    Mediocre post? Please Rate it.
    Reply With Quote Reply With Quote
  3. Sep 8th, 2005, 08:50 AM #3
    flukey2005
    flukey2005 is offline

    Thread Starter
    Member
    Join Date
    Apr 2005
    Posts
    51

    Re: MySQL console - adding more fields to a table

    oh thats how you do it.

    Thanks. Much appreciated.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width