Hi!
On Wed, Jul 25, 2001 at 10:32:38PM -0600, Chris Bolt wrote:
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
It is totaly useless to compare Oracle vs. MySQL.
Oracle is something you
OK, I understand this is something very basic, I should understand.
Maybe anybody can teach me the difference between:
mysql select floor(23.49 + 0.5);
++
| floor(23.49 + 0.5) |
++
|
Hi,
you may know the feature
create table xyz select * from xy...
which is similar to oracles select into table.
It works ok, only thing is that with this statement no indices are
created on the new table. Is this a bug?
Have a nice thread,
Peter
Hi,
how do I get something like ROWNUM with mysql?
This means, before every row in a result there would be the Number of
the row. I want a result that looks like this:
No | xyz | abc |
---
1| xyz | abc |
2| xyz | abc |
3| xyz | abc |
.
.
.
10| xyz |
HI,
If I understand your question, you need two queries:
select count(*) as count, ip, value from log group by ip
select count(*) as count, ip, value from log group by ip,value
that leads to the right direction! thanks! It shows me a the ips with
their values and how many times they are in the
Hi,
something, that gets quite near to what I want is:
select a.id, a.value, b.value
from test as a left join test as b on a.id=b.id
group by a.id, a.value having a.valueb.value;
It spits out the right data, but not the way I want...
++---+---+
| id | value | value |
Hi,
sometimes one has to have the feeling, that somebody wants to help to
get it done better! :) I think I got it:
select a.id, a.value from test as a left join test as b on a.id=b.id
where a.value b.value group by a.id,a.value;
Its good to check logtables!
Of course I would appreciate
Hi,
it would be nice to have a replicate-ignore-table for the Master also!
It works fine, but if one has to replicate only certain tables of a db
it would be good to have this.
It is not enough to have this on slave only, because we do not want to
send the data of whole databases across the