David, I am sorry but I have never used phpMyAdmin. I don't know what it can and cannot do.
What I am referring to as "the client" is the command-line interface tool that comes bundled with MySQL. If you are going to do any serious MySQL database administration, I *STRONGLY* encourage you spend some time and learn how to use it. It will allow you make MySQL do anything that MySQL is capable of doing. Here is a link to the manual's MySQL client tutorial. Now that you have had some experience with the product, it may be easier for you to follow along: http://dev.mysql.com/doc/mysql/en/Tutorial.html May I also *STRONGLY* encourage that you spend some time learning how to hand formulate SQL statements. There were a few good tutorials available in 1996 (the last time I went looking) so I assume there are several more available now. This will save your butt when you need a recordset that your GUI tools can't create for you. There are few major differences between SQL dialects (like: MS Access has a TRANSFORM() statement that MySQL doesn't have. Oracle uses a different JOIN syntax) but the basic functionality is all the same: create tables( with and without indexes, with and without restrictions), populate tables, get data, delete data, change data, delete tables, permit/revoke access privileges. By cross referencing the tutorial with the manual, you should be able to translate their samples into working MySQL statements. Trust me, it's time well spent. With kindest regards, Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Blomstrom <david_blomstrom@ To: [EMAIL PROTECTED] yahoo.com> cc: Fax to: 06/15/2004 01:41 Subject: Re: Tracking Down a Ghost Database PM --- [EMAIL PROTECTED] wrote: > > David, > > Try writing your queries to the screen (or as > comments into your HTML) then > running those queries *manually* from the MySQL > client. You should be able > to spot your design or logic errors pretty quickly. Thanks. I still haven't learned how to do that yet. Does phpMyAdmin count as a "MySQL client"? And if I want to find a good tutorial on how to do this, what key words would I search for. (I generally steer clear of the manual; it's a little too technical for me.) Thanks. __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
