inserting a wide table into a narrower table

[Amos Shapira]

(Off the top of my head on the phone)
"ALTER TABLE DROP COLUMN..."?
On Nov 3, 2012 5:24 AM, "Erez D" <erez0001 at 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 at cs.huji.ac.il
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20121103/57ce75b6/attachment.html>