Perhaps some kind soul could help me out with an SQL I have been trying all
day to get to work, where one colum is just not summing up the way I want it
to.
I have the following data

I have got the requirement for the database that the fields that
are search-able are not known up-front. In my mind I would need
one column for each field, and index those columns. A co-worker
has mentioned the use of some "lookup tables", but I can't see how

I have a very simple join which is taking nearly a minute to execute.
It uses the following two tables:
CREATE TABLE `candidates`
(

Can some one please help me. I need to access this database (I have been
told it's database) but I don't know how?
It's coming from machine made in Japan app. year 1994-1998 if it helps.
Below you can find short sample of it, rest is seen in comp.binaries.acorn

I have a few SQL backups restored from a set of backup files. The
backup files have been removed from the drive because of some storage
constrains...
For some data comparison reasons, I need to figure out the actual date

let's say at table has columns A, B and C and I do:
SELECT A, B, COUNT(*)
FROM    TABLE
GROUP BY A, B

Anyone please tell me what is SUPER KEY and how it is differentiated
from other keys like Candidate Keys and Minimal Keys.

" sorry if this is off post ...will be my last"
Thx in advance for your help and interest.
  i am an independant oil and gas consultant and have a fair
amount of computer experience but, am absolutely lost when it

my database is not very big so I want to adopt this backup strategy:
each 1 hour I want to clone the whole database 'mydatabase' to another
database 'currenttime_mydatabase' in order to have 24 backup a day,
overwriting the yesterday backups by today-same-time backups.

Could the experts here point me to books or web links
that show how one could use C# to connect to TimesTen database ?
Or any workarounds to connect to the database using C# ?
Appreciate any help.

I don't use graphical tools during development. My current customer wishes graphical models. So I'd like to have a tool which can reverse engineer my database and create a model.
Is there any reverse engineering tool which requires nearly no 'hand work'?
Any hint appreated.
Andreas

mysql in c++ initialize error occurs a simple program is executed in
redhat9.0 , using gcc 3.2.2 compiler version ...
#include <stdio.h>
#include <mysql.h>

Suppose a database server - say MySQL, though I'd be interested in
answers to my question for other systems too - and client are separated
by a low bandwidth link such as DSL, and the client repeatedly issues a
query for, say, a current product list.

I have a question about a query I would improve (I know it is not the best).
I have two tables:
USER:

I'm a designer with some basic database knowledge but I would like
some suggestions on a database design problem that's really too much
for me..
Here's the question: