MySQL Users,
I have a local website development environment where I have a "master"
MySQL database.
I have several web sites which use the exact same database structure.
The structure of the master database doesn't change very often, but it
does sometimes. When that happens, I want to be abl
Hi All,
We are planing to develop and high available mysql db.
Can anybody please point me to any good documentation. Also how stable is
MySQL cluster and replication.
regards
anandkl
On Fri, 2007-03-16 at 18:43 +0900, Dave M G wrote:
> MySQL Users,
>
> I have a local website development environment where I have a "master"
> MySQL database.
>
> I have several web sites which use the exact same database structure.
>
> The structure of the master database doesn't change very o
Hi!
I would start at:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication.html
Bye,
Ian
Ananda Kumar said the following, On 16-Mar-07 11:04:
> Hi All,
> We are planing to develop and high available mysql db.
> Can anybody please point me to any good documentation. Also how stable is
Hi,
Sometimes I see that some tables from my database get corrupted. Why does
this happpen and how can I avoid it?
It is not hard to go and use "repair table" but it seems that in this way
some records could be deleted and this is not ok.
If I want to have a very secure database, can I use MySQ
Hi All!
The first version of the PrimeBase XT storage engine for MySQL with
support for Windows NT/XP has just been released.
Since MySQL for Windows does not yet support runtime pluggable
engines, I have built the MySQL 5.1.16 server executable with the
PBXT storage engine compiled in.
Octavian Rasnita wrote:
Hi,
Sometimes I see that some tables from my database get corrupted. Why
does this happpen and how can I avoid it?
It is not hard to go and use "repair table" but it seems that in this
way some records could be deleted and this is not ok.
If I want to have a very secure
I have an app that I've converted to MySQL from MS SQL. I used to use the
following to force a Alpha field to sort as if it were numeric (I know,
perhaps it is better if I made the field numeric to begin with, but it's
not, and I don't remember why, but that's not the question here):
ORDER BY
Hello list,
I'm currently developing a newsletter tool allowing customers to send
their newsletters to their clients and get all kinds of statistics. For
each customer of ours, I need to save up to five different lists of
newsletter recipients with their email addresses and some other stuffs
I have two tables:
Table A:
Code | Name
100 | Name A
200 | Name B
300 | Name C
Table B:
Code | Date | Qty | Value
100 | 2007-01-01 | 10 | 123
100 | 2007-02-01 | -2 | 300
200 | 2007-02-01 | 3 | 100
What I want is to get this result:
Result Table on date example 2007-01-05:
Code | Name | Qty | Val
At 03:27 PM 3/16/2007, you wrote:
How to find all the values of column a in table A that are not values of
column b in table B?
Thanks
YL,
You need to do a Left Join and it will use NULL's for rows in the
second table if the row is missing.
select A.* from TableA TA left join TableB TB
At 6:56 PM +0200 3/16/07, Octavian Rasnita wrote:
Hi,
Sometimes I see that some tables from my database get corrupted. Why
does this happpen and how can I avoid it?
It is not hard to go and use "repair table" but it seems that in
this way some records could be deleted and this is not ok.
If I
From: "Steve Edberg" <[EMAIL PROTECTED]>
Sometimes I see that some tables from my database get corrupted. Why does
this happpen and how can I avoid it?
It is not hard to go and use "repair table" but it seems that in this way
some records could be deleted and this is not ok.
If I want to have a
I have a table:
Id |path1 | display| value
1 | ostype | os|windows
1 | ostype | ver |NT4
2 | ostype | os | linux
2 | ostype | ver | RHEL 5.4
That I would like to tranform into
Id | os| ver
1 |windows | NT4
2| linux |RHEL 5.4
Thank you,
Raymond
smime.p7s
14 matches
Mail list logo
