List:General Discussion« Previous MessageNext Message »
From:leegold Date:September 6 2005 4:10pm
Subject:RE: Newbie needs info!
View as plain text  
On Tue, 6 Sep 2005 10:58:28 -0500, "John Trammell"
<johnt@stripped> 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:jpaulson@stripped] 
> > Sent: Tuesday, September 06, 2005 10:56 AM
> > To: mysql@stripped
> > 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/mysql?unsub=1
> > 
> > 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
Thread
Newbie needs info!Jay Paulson6 Sep
  • Re: Newbie needs info!Peter Brawley6 Sep
RE: Newbie needs info!John Trammell6 Sep
  • RE: Newbie needs info!leegold6 Sep