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
But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.
Arun
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 18:38 -0800 12/27/02, Arun Kumar wrote:
> >Dear All,
> > I have a table 'X', I want to d
Dear All,
I have a table 'X', I want to display the record
in this table 'X' which has occupied the maximum
number of bytes, i.e i want a query/queries to
display the record with maximum size. I would also
like to print the
record size as well.
Any help in this front would be great.
Arun
--- [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to
> be either spam or
> simply off topic to our filter. To bypass the filter
> you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply to this message, and
I want to run mysqldump through a batch process, in
order to do that what prive do i need to give to the
user. It will be running as a cron job, i don't want
to give any creation or deletion authorization. Your
help will be greatly appreciated.
Regards
Arun
___
11 matches
Mail list logo
