;studied" your query, my guess would be: double rows. UNION
eliminates those; if you need them, use "UNION ALL". Just a guess though...
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
MySQL General Mailing List
For list archives: h
p database replication including a
failover solution (e.g. heartbeat).
You could in general do something similar with your webserver and other
systems.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
MySQL General Mailing List
For list archives: http:/
Konrad,
AZZOPARDI Konrad schrieb:
Hello people,
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems t
José I. Merino schrieb:
The main question is:
Will Oracle permits a cheaper DB in his portfolio with almost the same
reliability than his main and expensive DB?
It already has, it's called "Oracle Express Edition".
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.
index the crcval column.
From my understanding, a TRIGGER might do exactly what Thunder needs.
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
Ciao,
Thomas Pundt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
Hi,
[EMAIL PROTECTED] schrieb:
Hi,
I have 2 tables as follows:
table 1 contains code,order_qty
table 2 contains code,stock_qty
table 1:
code1, 10
code2, 2
code3, 5
table 2:
code1, 3
code3, 5
code1, 4
code3, 2
I need to see the following result:
code | order_qty| stock_qty
code1 | 10
columns (D, E, F) from table_2 if the columns don¹t exist in
| Table_1.
select a, b, c, null as d, null as e, null as f
from table_1
union
select a, b, c, d, e, f
from table_2
should do it.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
MySQL General M
