Jay
There's a short list of SQL & relational tutorials at
http://www.artfulsoftware.com/dbresources.html, and of a few MySQL
resources at http://www.artfulsoftware.com/mysqlinfo.html.
PB
----
Jay Paulson wrote:
Hi everyone,
Long time reader, first time poster.
I've been using MySQL for some years now and never really did any
advance stuff in it. I mainly do updates, deletes, and selects. My
selects aren't even that complex as I don't have a very good
understanding of the join syntax and exactly what it does. I was
wondering a few things. First of all what is a good book for
beginners/intermediate level people? I'd really like to learn more
complex query structure and how to optimize a database as a whole as
well as individual tables in the database (example what's the
difference between a primary key and just a regular key in a table?).
I'm also looking for something that can explain stored procedures and
why they are useful (I really don't have any clue about stored
procedures) as well as transactions, replication, and master/slave
databases. Finally, I'd like to figure out the difference between
each table type (MyISM and InnoDB etc).
Thanks for any help or advice!
jay
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/90 - Release Date: 9/5/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]