"OF COURSE IT'S A GOOD IDEA!" - god replying to Arthur in Monty Python "Quest for the holly grail" :) On Nov 3, 2012 7:50 PM, "Erez D" <erez0...@gmail.com> wrote:
> > > On Sat, Nov 3, 2012 at 10:08 AM, Amos Shapira <amos.shap...@gmail.com>wrote: > >> Then load it then alter the table. >> > actually that was a good idea > > originally i didn't want it as i needed to merge two tables with different > widths > > in the end, i created a new database, imported the table, dropped some > columns, and exported it again > then appended it to mythtv's db > > > thanks. > >> On Nov 3, 2012 7:02 PM, "Erez D" <erez0...@gmail.com> wrote: >> >>> >>> >>> On Sat, Nov 3, 2012 at 12:48 AM, Amos Shapira <amos.shap...@gmail.com>wrote: >>> >>>> (Off the top of my head on the phone) >>>> "ALTER TABLE DROP COLUMN..."? >>>> >>> i do not have the old table, just the mysqldump file ... >>> >>> >>>> On Nov 3, 2012 5:24 AM, "Erez D" <erez0...@gmail.com> wrote: >>>> >>>>> hello, >>>>> >>>>> i am downgrading mythtv. to keep my data, i need to import my >>>>> recording table >>>>> however in the older version the table has less columns >>>>> i have a mysqldump of the wider table and need to insert into older >>>>> version with narrower table. >>>>> >>>>> i thought about using awk to delete the non relevant fields. however >>>>> there are man "," inside strings, so splitting fields by "," is not simple >>>>> >>>>> >>>>> any simple idea ? some sql magic ? >>>>> >>>>> thanks, >>>>> erez. >>>>> >>>>> _______________________________________________ >>>>> Linux-il mailing list >>>>> Linux-il@cs.huji.ac.il >>>>> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il >>>>> >>>>> >>> >
_______________________________________________ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
