Is it possible to rename a database?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
Please strike previous message the query should be:
SELECT location, date, type, price,
FROM products
ORDER BY location, date, type
Group By location, date, type
COMPUTE SUM(price)
-Original Message-
From: Brandon Lewis [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 2:14 PM
To
Okay I may have been a bit vague on my description.
SELECT location, date, type, price,
FROM products
ORDER BY location, type, date
Group By location, type
COMPUTE SUM(price)
Is there something similar for compute?
-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED]]
Sent: Mo
I take it the Computer SQL Function is not support by MySQL and if not is
there a substitute for it?
If you are unfamiliar with the command it works like this:
SELECT type, price
FROM products
ORDER BY type
COMPUTE SUM(price)
You will get a summary of prices by type in your results.
Foreign Keys are nice but they are costly items to use, best enforce the
reference in your business logic of your application. You can still join and
look up based on references but the database is not responsible for
enforcing the relationship. Believe me they knew what they where doing when
they
Not only database design but system as well. Drive speed, drive
fragmentation and I/O resources can play a large factor in database speed.
Could you have a better disk environment on the Solaris machine versus the
win32-machine?
-Original Message-
From: Ansgar Becker [mailto:[EMAIL PROTE
Hello, I have been looking into some Access Violations I am getting with a
client app accessing a MySQL database on an NT 4.0 box. I have read the
article 24.1.5 How to make a Thread Safe Client but I am still some what
confused. Is there a limit to the number of threads one database connectio
