inserting a wide table into a narrower table

[Amos Shapira]

"OF COURSE IT'S A GOOD IDEA!" - god replying to Arthur in Monty Python
"Quest for the holly grail" :)
On Nov 3, 2012 7:50 PM, "Erez D" <erez0001 at gmail.com> wrote:

>
>
> 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/7e112895/attachment.html>