inserting a wide table into a narrower table

[Erez D]

On Sat, Nov 3, 2012 at 10:08 AM, Amos Shapira <amos.shapira at 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" <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/81c57024/attachment.html>