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 'custom
ep 28, 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:
-bin.001
-bin.002
-bin.003
etc. (obviously with being replaced with the name of the
computer)
I also have files like...
inn
On my mysql servers, I've noticed some unexpected files in the
/usr/local/mysql/data/ directory.
Specifically, I have files like:
-bin.001
-bin.002
-bin.003
etc. (obviously with being replaced with the name of the
computer)
I also have files like...
innodb.status.410
innodb.status.411
innodb.st
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 'ticket_number'
ication I
would either lock the tables to prevent outside updates during the
computation, or I would wrap the whole process with a transaction. That
way you can avoid updating the balance with only part of the
information.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
R
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 customer
