Re: SQL book recommendation?

2010-10-29 Thread Philip Riebold

On 28 Oct 2010, at 18:45, Paul DuBois wrote:

 
 On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:
 
 
 On 26 Oct 2010, at 11:49, MikeB wrote:
 
 I'm finding the MySQL online manuals hard going in figuring out how to 
 construct SQL queries. Can anyone perhaps recommend a good book that can 
 shed light on the subject?
 
 Thanks.
 
 The book I've been using is 'MySQL, The definitive guide to using, 
 programming, and administering MySQL 4.1 and 5.0' ISBN 0-672-32673-6 (there 
 may be a more recent version).
 
 If that's my book, it sounds like the third edition. The fourth edition is 
 more recent. http://www.kitebird.com/mysql-book/

Yes, I've just checked I have the third edition.

I'll probably keep my copy (I'm not a particularly heavy user of MySQL) but 
would recommend anybody looking for a book to get the 4th edition rather than 
the 3rd 

--
TTFN.

   Philip Riebold, p.rieb...@ucl.ac.uk   /\
   Media Services\ /
   University College London  X  ASCII Ribbon Campaign
   Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail
   London, W1T 4JF
   +44 (0)20 7679 9259 (direct), 09259 (internal)





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: SQL book recommendation?

2010-10-28 Thread Paul DuBois

On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:

 
 On 26 Oct 2010, at 11:49, MikeB wrote:
 
 I'm finding the MySQL online manuals hard going in figuring out how to 
 construct SQL queries. Can anyone perhaps recommend a good book that can 
 shed light on the subject?
 
 Thanks.
 
 The book I've been using is 'MySQL, The definitive guide to using, 
 programming, and administering MySQL 4.1 and 5.0' ISBN 0-672-32673-6 (there 
 may be a more recent version).

If that's my book, it sounds like the third edition. The fourth edition is more 
recent. http://www.kitebird.com/mysql-book/


 
 Well written, with a general introduction to SQL and (from my POV) very good 
 sections on writing MySQL with C and PHP
 
 --
 TTFN.
 
   Philip Riebold, p.rieb...@ucl.ac.uk   /\
   Media Services\ /
   University College London  X  ASCII Ribbon Campaign
   Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail
   London, W1T 4JF
   +44 (0)20 7679 9259 (direct), 09259 (internal)

-- 
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: SQL book recommendation?

2010-10-28 Thread Mike OK

I have two of Paul's books and they are excellent.


- Original Message - 
From: Paul DuBois paul.dub...@oracle.com

To: [MySQL] Mysql list mysql@lists.mysql.com
Cc: MikeB mpbr...@gmail.com; Philip Riebold p.rieb...@ucl.ac.uk
Sent: Thursday, October 28, 2010 1:45 PM
Subject: Re: SQL book recommendation?



On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:



On 26 Oct 2010, at 11:49, MikeB wrote:

I'm finding the MySQL online manuals hard going in figuring out how to 
construct SQL queries. Can anyone perhaps recommend a good book that can 
shed light on the subject?


Thanks.


The book I've been using is 'MySQL, The definitive guide to using, 
programming, and administering MySQL 4.1 and 5.0' ISBN 0-672-32673-6 
(there may be a more recent version).


If that's my book, it sounds like the third edition. The fourth edition is 
more recent. http://www.kitebird.com/mysql-book/





Well written, with a general introduction to SQL and (from my POV) very 
good sections on writing MySQL with C and PHP


--
TTFN.

  Philip Riebold, p.rieb...@ucl.ac.uk   /\
  Media Services\ /
  University College London  X  ASCII Ribbon Campaign
  Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail
  London, W1T 4JF
  +44 (0)20 7679 9259 (direct), 09259 (internal)


--
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=mike_...@acorg.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: SQL book recommendation?

2010-10-27 Thread wroxdb
2010/10/26 Philip Riebold p.rieb...@ucl.ac.uk:

 On 26 Oct 2010, at 11:49, MikeB wrote:

 I'm finding the MySQL online manuals hard going in figuring out how to 
 construct SQL queries. Can anyone perhaps recommend a good book that can 
 shed light on the subject?

 Thanks.

 The book I've been using is 'MySQL, The definitive guide to using, 
 programming, and administering MySQL 4.1 and 5.0' ISBN 0-672-32673-6 (there 
 may be a more recent version).



I also suggest the book High Performance Mysql which is good for
mysql dev and admin.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: SQL book recommendation?

2010-10-26 Thread Jay Blanchard
[snip]
I'm finding the MySQL online manuals hard going in figuring out how to 
construct SQL queries. Can anyone perhaps recommend a good book that can

shed light on the subject?
[/snip]

http://www.peachpit.com/store/product.aspx?isbn=0321375734

MySQL, Second Edition: Visual QuickStart Guide, 2nd Edition - Larry
Ullman

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: SQL book recommendation?

2010-10-26 Thread Philip Riebold

On 26 Oct 2010, at 11:49, MikeB wrote:

 I'm finding the MySQL online manuals hard going in figuring out how to 
 construct SQL queries. Can anyone perhaps recommend a good book that can shed 
 light on the subject?
 
 Thanks.

The book I've been using is 'MySQL, The definitive guide to using, programming, 
and administering MySQL 4.1 and 5.0' ISBN 0-672-32673-6 (there may be a more 
recent version).

Well written, with a general introduction to SQL and (from my POV) very good 
sections on writing MySQL with C and PHP

--
TTFN.

   Philip Riebold, p.rieb...@ucl.ac.uk   /\
   Media Services\ /
   University College London  X  ASCII Ribbon Campaign
   Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail
   London, W1T 4JF
   +44 (0)20 7679 9259 (direct), 09259 (internal)





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: SQL book recommendation?

2010-10-26 Thread Jerry Schwartz
You might want to use an on-line introductory course, if you have time for the 
leisurely pace.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com


-Original Message-
From: Philip Riebold [mailto:p.rieb...@ucl.ac.uk]
Sent: Tuesday, October 26, 2010 7:31 AM
To: MikeB
Cc: mysql@lists.mysql.com
Subject: Re: SQL book recommendation?


On 26 Oct 2010, at 11:49, MikeB wrote:

 I'm finding the MySQL online manuals hard going in figuring out how to
construct SQL queries. Can anyone perhaps recommend a good book that can shed
light on the subject?

 Thanks.

The book I've been using is 'MySQL, The definitive guide to using, 
programming,
and administering MySQL 4.1 and 5.0' ISBN 0-672-32673-6 (there may be a more
recent version).

Well written, with a general introduction to SQL and (from my POV) very good
sections on writing MySQL with C and PHP

--
TTFN.

   Philip Riebold, p.rieb...@ucl.ac.uk   /\
   Media Services\ /
   University College London  X  ASCII Ribbon Campaign
   Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail
   London, W1T 4JF
   +44 (0)20 7679 9259 (direct), 09259 (internal)





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



Re: SQL book recommendation?

2010-10-26 Thread Arthur Fuller
Visit our site (www.artfulsoftware.com) for lots of tips, especially on
queries.

Arthur

  -Original Message-
 From: Philip Riebold [mailto:p.rieb...@ucl.ac.uk]
 Sent: Tuesday, October 26, 2010 7:31 AM
 To: MikeB
 Cc: mysql@lists.mysql.com
 Subject: Re: SQL book recommendation?
 
 
 On 26 Oct 2010, at 11:49, MikeB wrote:
 
  I'm finding the MySQL online manuals hard going in figuring out how to
 construct SQL queries. Can anyone perhaps recommend a good book that can
 shed
 light on the subject?
 
  Thanks.