inserting a wide table into a narrower table

[Erez D]

On Sat, Nov 3, 2012 at 12:48 AM, Amos Shapira <amos.shapira at 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" <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/c119651d/attachment.html>