Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010

    How can I add this column to my Mysql DB?

    Hello again all,

    I have a quick question . Now I have to CSV files, I imported one in to make a database. The other CSV has a matching ID but an extra column that I would like to add onto the other DB, matching the IDs.

    Any idea how I can do this?

    Thanx in advance...

  2. #2
    Join Date
    Nov 2009
    phpmyadmin is your friend. It has a nice web gui so you can just modify the table by adding the column you need. It should be standard with your web hosting control panel, most likely cPanel.
    Energized I.T. Web Hosting
    Hosting | Template Customization | Domain Names
    Ministry Web Hosting

  3. #3
    Join Date
    Apr 2011
    Mysql Workbench is a desktop based GUI program for working with mysql databases if phpmyadmin is not included with your web host although it might not work as some hosts might restrict mysql login to localhost.

  4. #4
    Join Date
    Aug 2010
    I have phpmyadmin - I can add the column but how do I make the entries sync with their User IDs ? (both tables have the User_Id attached)

Similar Threads

  1. mysql 5: Duplicate column name
    By Satch in forum Programming Discussion
    Replies: 1
    Last Post: 01-30-2011, 05:28 PM
  2. Replies: 6
    Last Post: 05-30-2010, 09:35 PM
  3. MYSQL default column value
    By Glath in forum Programming Discussion
    Replies: 1
    Last Post: 05-22-2006, 03:10 PM
  4. Replies: 2
    Last Post: 05-29-2005, 02:20 PM
  5. [PHP / MySql] Add new column and fill it out
    By Wojtek in forum Programming Discussion
    Replies: 2
    Last Post: 02-22-2004, 07:24 PM

Posting Permissions

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