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
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
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
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
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
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 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
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
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.
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!
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
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 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
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
14 matches
Mail list logo