--- [EMAIL PROTECTED] wrote:
>
> 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.
Yes, I'll have to set aside some time to learn that
stuff. I'll probably spend the next few days getting
my "rough draft" database up and running, then I'll go
back and review the basics for my revision.
Thanks for the tips.
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
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]
