"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" wrote:
>
>
> On Sat, Nov 3, 2012 at 10:08 AM, Amos Shapira wrote:
>
>> Then load it then alter the table.
>>
> actually that was a good idea
>
> originally i didn
On Sat, Nov 3, 2012 at 10:08 AM, Amos Shapira 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
Then load it then alter the table.
On Nov 3, 2012 7:02 PM, "Erez D" wrote:
>
>
> On Sat, Nov 3, 2012 at 12:48 AM, Amos Shapira 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:2
On Sat, Nov 3, 2012 at 12:48 AM, Amos Shapira 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" wrote:
>
>> hello,
>>
>> i am downgrading mythtv. to keep my data, i need t
(Off the top of my head on the phone)
"ALTER TABLE DROP COLUMN..."?
On Nov 3, 2012 5:24 AM, "Erez D" 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 tabl
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
