1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Best way to merge column from one table to another in mysql

Discussion in 'MySQL' started by xbat, Sep 29, 2013.

  1. #1
    Heres what I am doing and I am trying to cut back on some steps here..

    I have table_all_combine

    I then have table_hair_info >> then colors

    I want to take colors column and put it in the colors_1 column in table combine I keep getting stuck where colors have a dash in them like >> 88-99


    I then want to take another table and add in rest of colors from description etc to table_combine_all

    Anyone know of any easy way of doing this? Or is there some tutorial somewhere on the web that shows you how to do this? Anyway of doing this with mysql workbench or some other easy program?

    Heres the code I was using
    insertinto tablename
    (col1_name)select(col2_name)from tablename;

    I'm not sure why it was splitting the data....???
     
    xbat, Sep 29, 2013 IP
  2. xbat

    xbat Well-Known Member

    Messages:
    326
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    105
    #2
    i found a simple solution in just running a simple query in phpmyadmin.
     
    xbat, Oct 7, 2013 IP