(Off the top of my head on the phone) "ALTER TABLE DROP COLUMN..."? 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
