Man, you're awesome. Only two typos in the whole procedure. However, for the
life of me, I'm puzzled over how it works. If you have more patience can you
explain?
Correct query (table is singular, not PHPAUCTIONS_...):
CREATE TEMPORARY TABLE tmpWinners SELECT auction, max(bid) as winningbid
FRO
Shawn, thank you for your complete answer. I'm still working through your first
post. I apologize for not noticing this FAQ. I didn't take it into account
because I thought it only applied to MySQL 5 and I'm using 4.0.24.
Thanks, again. I'll be in touch regarding your first post as I work with y
a nested SELECT, but I couldn't make any of
my attempts work. Could someone please help me construct an SQL query which
would just print out the correct winners for each auction? I'm using MySQL
4.0.24 in Debian sarge.
Thanks for your advice and suggestions.
-Kevin Zembower
-
E.
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine, not the
other way around, which is more typically the case. If we go with
MS SQL Server, we'll build a separate host, NT I would guess, to
host it. I'm only responsible for Unix and Linux boxes here, so
Martijn, thank you very much for your analysis. I hope others will continue to join in.
With regard to your point quoted below, are you referring to PostgreSQL, and would
that be a
stronger competitor to MS SQL Server 2000 than either the current version of MySQL or
MySQL 5?
Thanks, again, for
out what we hope to do
with an SQL engine, but I don't think it will be very sophisticated.
Thank you for all your thoughts and comments.
-Kevin Zembower
-
E. Kevin Zembower
Unix Administrator
Johns Hopkins University/Center for Communications Programs
111 Market Place, Suite 310
Balti
tabases and the mysql database itself. All the
reference books I have talk about the GRANT CREATE privilege with regard to tables,
not databases.
Any suggestions?
Thank you.
-Kevin Zembower
-
E. Kevin Zembower
Unix Administrator
Johns Hopkins University/Center for Communications Programs
1
aware that I could have just typed the whole thing in an INSERT statement more
quickly and with fewer keystrokes that typing this note, but I'm the curious type.]
Thanks for your thoughts.
-Kevin Zembower
-
E. Kevin Zembower
Unix Administrator
Johns Hopkins University/Center for
#x27;','N','N','N','N','N','N','N','N','N','N','N','N','N','N'
www:~ #
Any suggestions for further diagnostics and solutions?
Thanks, again, everybody, f
---+++
1 row in set (0.01 sec)
mysql>
Thanks for trying to give me a hand. I'm open to other suggestions.
-Kevin
Zembower
>>> Chris Cooper <[EMAIL PROTECTED]> 11/14/01 02:46PM >>>
http://www.mysql.com/doc/P/r/Privilege_changes.htm
estion to run
mysql_fix_privilege_tables. It seemed to run correctly, but didn't change anything.
Thanks for helping this newbie.
-Kevin Zembower
-
E. Kevin Zembower
Unix Administrator
Johns Hopkins University/Center for Commun
11 matches
Mail list logo