I have a database that contains a cable of 'customers'. 'Customers'
does not change on a regular basis but is queried frequently so I have
setup a 'customers_cache' table, which is exactly the same as
'customers', except 'customers_cache' is a memory based table. Before
doing a query on
On my mysql servers, I've noticed some unexpected files in the
/usr/local/mysql/data/ directory.
Specifically, I have files like:
hostname-bin.001
hostname-bin.002
hostname-bin.003
etc. (obviously with hostname being replaced with the name of the
computer)
I also have files like...
, 2004, at 4:49 AM, Rob Best wrote:
On my mysql servers, I've noticed some unexpected files in the
/usr/local/mysql/data/ directory.
Specifically, I have files like:
hostname-bin.001
hostname-bin.002
hostname-bin.003
etc. (obviously with hostname being replaced with the name of the
computer)
I also
This is probably a very easy question for many of you.
I have two tables, 'Purchases' and 'Purchased_Items'.
For every purchase there is one entry in 'Purchases' and 1 or more
entries on 'Purchased_Items' (depending on how many items were
purchased'.
The two tables are linked by a
I hope this isn't a stupid question but this is my best place to ask...
I have a database where I need to do a sum of a returned select...
SELECT SUM(purchases.amount_of_credit_used) WHERE customer_id=jdoe;
and do a sum of another returned select...
SELECT SUM(amount) from deposits WHERE
. That
way you can avoid updating the balance with only part of the
information.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Rob Best [EMAIL PROTECTED] wrote on 07/23/2004 07:24:02 AM:
I hope this isn't a stupid question but this is my best place to
ask...
I have