Re: Problems finding the MAX value

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

Re: Problems finding the MAX value

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

Problems finding the MAX value

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.

Re: Need help comparing MySQL to MS SQL Server

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

Re: Need help comparing MySQL to MS SQL Server

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

Need help comparing MySQL to MS SQL Server

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

Safe way to allow users to create databases?

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

Duplicating records with a changed field?

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

Re: Newbie: Can't get GRANT to work

#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

Re: Newbie: Can't get GRANT to work

---+++ 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

Newbie: Can't get GRANT to work

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