All;
I am having tremendous trouble attempting to do the following query; and any
help would be appreciated.
I am using Mysql 4.0.15a; and I cannot upgrade.
Given the following TEMPORARY table (it's a table I have created from a whole
host of sources):
table: endtime_table
+
lets say i have a query the returns me the following data:
+++-+-+-+-+
| status | id | case_id | analysis1 | analysis2 | analysis3 |
+++-+-+-+-+
| FAILED | 1 |
I have a general DB question, but since I'm using MySQL, I figure one of
our friendly listreaders might be able to help me out.
I have 4 tables, say "table1-table4", and I need to get some data from
table4 which relies on some values from table1. However, the only way I
can get those table1 v
Question:
given data in a table such as
id, value, date
0, value1, 1999-01-25
1, value2, 1999-01-02
2, value2, 1999-01-04
3, value1, 1999-01-22
4, value2, 2000-01-01
how can i select the latest 'id' for a given same set of 'value' based on
'date'? ie: i would like to be able to get records id
> > I was wondering, is it possible to have different log files for
> > different databases somehow?
>
>RedBack? You're just down the street... Sort of.
Ya, but for how long (for either of us). ahem.
>difficult to do (add the necessary code to MySQL), provided that the
>logging code is as
Hello all,
I was wondering, is it possible to have different log files for different
databases somehow?
For instance, I have running on a server 5 different databases, so when I
tail the log files, I am seeing transactions for them all. Becomes a bit
of a pain when debugging and such, so I was
I have 3 tables that I am joining together based on that fact that one (or
more) values appear in the 2nd table, but those values that need to appear
are garnered from the 3rd table (and i want the id that is associated by
the 1st table). Err well, an example would be better:
Table 1:
id ->
