RE: Newbie needs info!
The DuBois book is a good start: http://www.kitebird.com/mysql-book/ -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]
RE: Newbie needs info!
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]
Re: Newbie needs info!
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]