On Tue, 6 Sep 2005 10:58:28 -0500, "John Trammell" <[EMAIL PROTECTED]> said: > The DuBois book is a good start: http://www.kitebird.com/mysql-book/
This might be too basic but it's really clear: http://www.w3schools.com/sql/default.asp > > > -----Original Message----- > > From: Jay Paulson [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, September 06, 2005 10:56 AM > > To: mysql@lists.mysql.com > > Subject: Newbie needs info! > > > > 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 > > > > > > -- > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
