easy way to do it.
On Wed, Apr 16, 2008 at 5:30 PM, Arun Kumar PG <[EMAIL PROTECTED]>
wrote:
> hi,
>
> is there any other best way add a new column to an existing table having
> 60+ million records. alter is taking more than 1.5 hours.. what are the best
> practices around thi
hi,
is there any other best way add a new column to an existing table having 60+
million records. alter is taking more than 1.5 hours.. what are the best
practices around this. quick help will be appreciated.
--
cheers,
- a
great. thx!
On 4/17/07, Daniel Kasak <[EMAIL PROTECTED]> wrote:
Arun Kumar PG wrote:
> Guys,
>
> I know this is a stupid thing but I wanted to know if we have an index
> on a
> column "X" and if i have a query having 1 OR conditions on the
> field e.g.
&g
Guys,
I know this is a stupid thing but I wanted to know if we have an index on a
column "X" and if i have a query having 1 OR conditions on the field e.g.
where X=10 OR x=12 OR x=13 OR x=15.. so on then will it give any
benefits in terms of speed?
thx
- A
But this slave can not have direct access to the master. Is
there a way I can achive this?
If the slave cannot have access to Master how can we call it as a Slave. I
would rather call that as a server where you want to dump the mysql/data
directory of the Master. better write a nightly shell scr
http://www.mysql.com/products/tools/migration-toolkit/
There is a video presentation as well here for ORacle to MySQL migration.
Thanks,
- Arun
On 3/12/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Friends,
Does any body know of any tool available for migrating data from oracle to
mysql. C
SELECT * FROM Dog GROUP BY FooId HAVING FooId = 1;
This should also work.
On 1/5/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi,
> dog
> fooID int
> size int
> id int
>
> dog
> fooIDsizeid
>1 2 1
>2 5 2
>1 5 3
>
> if i do a query
> sel
