inserting a wide table into a narrower table

[Amos Shapira]

Then load it then alter the table.
On Nov 3, 2012 7:02 PM, "Erez D" <erez0001 at gmail.com> wrote:

>
>
> 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/53289a74/attachment-0001.html>