MySQL 5 certification books / trainign material
Good day everyone I think I have asked this question a while back but cant remember whether I have received an answer yet so I will ask again. I am busy studying for my MySQL certification exams, however the only book I have available to me is the MySQL 4 manual. The online pdf versions (for version 5.0 from the mysql website) seem to not be covering quite a bit of the info that is shown as requirements for the exam (or I am just being stupid and not finding it) My first exam is in 13 days and I have been struggling to find the relevant books or resources in order for me to get the study information I need. I tried Amazon,etc... but Amazon apparently does not deliver in SA anymore and the SA sites all show that the suppliers are out of stock. I managed to find one place today that had stock but shipment will take 25 working days which I do not have at this point. Does anybody know where I can get hold of a MySQL 5 certification study guide? Even if it is in pdf format or at this stage even if it has been used before. I would really appreciate the help with this as I can't even seem to get hold of someone at oracle to provide me with possible assistance as they all just say they don't know. Regards Machiel
good books or URL for mysql sql tunning
Hi All, Can u please guide me to any good books or URL for mysql sql tunning.. regards anandkl
Re: good books or URL for mysql sql tunning
Hi Anada, I recommend MySQL Database Design and Tuning by Robert Schineider. It covers everything from benchmark testing to Innodb Performance Enhancements. I'm 85% done with the book myself. It shows and explains good command-line and MySql Admin tool examples. The techniques discuss in this book are definitely key for large scaling applications. On Wed, Aug 13, 2008 at 7:30 AM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, Can u please guide me to any good books or URL for mysql sql tunning.. regards anandkl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: good books or URL for mysql sql tunning
On Wed, Aug 13, 2008 at 7:30 AM, Ananda Kumar [EMAIL PROTECTED] wrote: Can u please guide me to any good books or URL for mysql sql tunning.. http://www.highperfmysql.com/ - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Books on MySQL 5
As always, thanks ahead of time for all responses. The company I work for is currently looking at getting literature on MySQL 5, more specifically, what's different in new MySQL features from the SQL standard. By this I mean things such as Stored Procedures, Foreign Keys, and anything else I might have missed. I know there's: Beginning MySQL Database Design and Optimization: From Novice to Professional (Apress, 2004) And it does say it covers MySQL5, I'm just not sure to what extent. -- Chris White PHP Programmer/DB Virus Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books on MySQL 5
Hello, You might want to check out Guy Harrison's book on SP's. http://www.amazon.com/gp/product/0596100892/102-8915813-3282553?v=glancen=2 83155 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 2:16 PM To: mysql@lists.mysql.com Subject: Books on MySQL 5 As always, thanks ahead of time for all responses. The company I work for is currently looking at getting literature on MySQL 5, more specifically, what's different in new MySQL features from the SQL standard. By this I mean things such as Stored Procedures, Foreign Keys, and anything else I might have missed. I know there's: Beginning MySQL Database Design and Optimization: From Novice to Professional (Apress, 2004) And it does say it covers MySQL5, I'm just not sure to what extent. -- Chris White PHP Programmer/DB Virus Interfuel -- 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: Books on MySQL 5
Well I have the book you mentioned below - it is VERY good IMHO. Goes into alot of detail on how to design tables the right way. Covers normalisation and optimisation techniques for the server itself. These guys really know what they are talking about. I also have Beginning PHP MySQL 5, by Apress. This takes a look at the new features of MySQL 5, including triggers, views and stored procedures. Also covers MySQLi the new interface for MySQL. I've not read the whole book yet, but it seems to complement the above mentioned book very well. So I don't think you would go far wrong by getting these two books together. Regards Keith Roberts In theory, theory and practice are the same; in practice they are not. On Fri, 9 Jun 2006, Chris White wrote: To: mysql@lists.mysql.com From: Chris White [EMAIL PROTECTED] Subject: Books on MySQL 5 As always, thanks ahead of time for all responses. The company I work for is currently looking at getting literature on MySQL 5, more specifically, what's different in new MySQL features from the SQL standard. By this I mean things such as Stored Procedures, Foreign Keys, and anything else I might have missed. I know there's: Beginning MySQL Database Design and Optimization: From Novice to Professional (Apress, 2004) And it does say it covers MySQL5, I'm just not sure to what extent. -- Chris White PHP Programmer/DB Virus Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Books
Kieran Kelleher wrote: This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks after MySQL installations for Yahoo.com) (fix the link if it wordwraps in this email): http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20? creative=327641camp=14573link_code=as1 -Kieran I have mysql from Paul Duboir, 2nd ed here. Very complete. However, I like high performance mysql more because it is close to what I do - sysadmin/dba. I also read MySQL enterprise solutions. Good, but I like the two others more. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Books
Very good feedback on multiple books. Thank you. So many good choices. If only I had time to read them all... Jonathan Ugo Bellavance [EMAIL PROTECTED] 11/23/04 7:46 am Kieran Kelleher wrote: This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks after MySQL installations for Yahoo.com) (fix the link if it wordwraps in this email): http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20? creative=327641camp=14573link_code=as1 -Kieran I have mysql from Paul Duboir, 2nd ed here. Very complete. However, I like high performance mysql more because it is close to what I do - sysadmin/dba. I also read MySQL enterprise solutions. Good, but I like the two others more. -- 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: MySQL Books
Sasha, Plugs from authors are interesting, but plugs from readers are what really sell a book. I will check it out though. Thank you for the response. Jonathan Sasha Pachev [EMAIL PROTECTED] 11/19/04 5:36 pm Jonathan Duncan wrote: I have the MySQL first edition book by Paul. Still a great reference. However, it being a bit outdated I was hoping to get a more current book and one with more examples, since I learn best by example. The first book has good examples, but more would still help. Therefore, I was comparing reviews online for the following two books: -MySQL, Second Edition by Paul DuBois -Mastering MySQL 4 by Ian Gilfillan Any preferences between these two? Any better suggestions for learning MySQL front and back from a DBA perspective to an end user perspective? Jonathan: May I offer a shameless plug? MySQL Enterprise Solutions. Being the first book I've ever written, it does have its weaknesses, but also has its strengths. For every configuration variable in Chapter 14, and for every status variable in Chapter 15 I went to the source to make sure I understood what was going on behind the scenes before I wrote the description. It is also the only book that I know of so far that discusses MySQL internals (I am working on another one dedicated solely to MySQL Internals). It was written in 2002, so it does focus on 3.23-4.0. However, this is not that big of a minus. Due to the strong commitment of the MySQL team to backwards compatibility, most if not almost everything the book says applies to 4.1 and 5.0. It is just that the newer versions have some new features and options that the book does not cover. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- 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: MySQL Books
This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks after MySQL installations for Yahoo.com) (fix the link if it wordwraps in this email): http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20? creative=327641camp=14573link_code=as1 -Kieran Dev Config = OS X 10.3.5 / Java 1.4.2_05 / WO 5.2.3 / XCode v1.5 / MySQL 4.0.20 / Connector-J 3.0.11 Deploy Config = OS X 10.3.5 Server / Java 1.4.2_05 / WO 5.2.3 / MySQL 4.0.20 / Connector-J 3.0.11 My Blog: http://mysqlwithwebobjects.webhop.org/ On Nov 22, 2004, at 7:34 PM, Jonathan Duncan wrote: Sasha, Plugs from authors are interesting, but plugs from readers are what really sell a book. I will check it out though. Thank you for the response. Jonathan Sasha Pachev [EMAIL PROTECTED] 11/19/04 5:36 pm Jonathan Duncan wrote: I have the MySQL first edition book by Paul. Still a great reference. However, it being a bit outdated I was hoping to get a more current book and one with more examples, since I learn best by example. The first book has good examples, but more would still help. Therefore, I was comparing reviews online for the following two books: -MySQL, Second Edition by Paul DuBois -Mastering MySQL 4 by Ian Gilfillan Any preferences between these two? Any better suggestions for learning MySQL front and back from a DBA perspective to an end user perspective? Jonathan: May I offer a shameless plug? MySQL Enterprise Solutions. Being the first book I've ever written, it does have its weaknesses, but also has its strengths. For every configuration variable in Chapter 14, and for every status variable in Chapter 15 I went to the source to make sure I understood what was going on behind the scenes before I wrote the description. It is also the only book that I know of so far that discusses MySQL internals (I am working on another one dedicated solely to MySQL Internals). It was written in 2002, so it does focus on 3.23-4.0. However, this is not that big of a minus. Due to the strong commitment of the MySQL team to backwards compatibility, most if not almost everything the book says applies to 4.1 and 5.0. It is just that the newer versions have some new features and options that the book does not cover. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- 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 Books
I have the MySQL first edition book by Paul. Still a great reference. However, it being a bit outdated I was hoping to get a more current book and one with more examples, since I learn best by example. The first book has good examples, but more would still help. Therefore, I was comparing reviews online for the following two books: -MySQL, Second Edition by Paul DuBois -Mastering MySQL 4 by Ian Gilfillan Any preferences between these two? Any better suggestions for learning MySQL front and back from a DBA perspective to an end user perspective? Thanks, Jonathan Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Books
Jonathan Duncan wrote: I have the MySQL first edition book by Paul. Still a great reference. However, it being a bit outdated I was hoping to get a more current book and one with more examples, since I learn best by example. The first book has good examples, but more would still help. Therefore, I was comparing reviews online for the following two books: -MySQL, Second Edition by Paul DuBois -Mastering MySQL 4 by Ian Gilfillan Any preferences between these two? Any better suggestions for learning MySQL front and back from a DBA perspective to an end user perspective? Jonathan: May I offer a shameless plug? MySQL Enterprise Solutions. Being the first book I've ever written, it does have its weaknesses, but also has its strengths. For every configuration variable in Chapter 14, and for every status variable in Chapter 15 I went to the source to make sure I understood what was going on behind the scenes before I wrote the description. It is also the only book that I know of so far that discusses MySQL internals (I am working on another one dedicated solely to MySQL Internals). It was written in 2002, so it does focus on 3.23-4.0. However, this is not that big of a minus. Due to the strong commitment of the MySQL team to backwards compatibility, most if not almost everything the book says applies to 4.1 and 5.0. It is just that the newer versions have some new features and options that the book does not cover. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: recommended books for web app.
Peter, If you put any in your email reply - none came through. Kerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 August 2004 05:21 To: [EMAIL PROTECTED] Subject: Re: recommended books for web app. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recommended books for web app.
Kerry, At 08:09 AM 8/12/2004, you wrote: I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a master/detail table relationship. I need to be aware of securing the database and have been told by others that I should look to use PHP. I know my local bookstore has the following publications (based on asking about MySQL PHP) Beginning PHP, Apache MySQL Web Development published by Wrox PHP MySQL written by Larry Ullmen I'd recommend this one first (actually he has 2 books on PHP MySQL, an intro and an advanced version) because it will get you the basics for using PHP and MySQL. You can also finish each one in about a week because it is not that large. PHP MySQL Web Development written by Luke Welling Laura Thomsan Read this book next because it is quite thorough and will take some time to get through. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: recommended books for web app.
Thanks Mike, your recommendations are very much noted. Kerry -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: 15 August 2004 17:22 To: [EMAIL PROTECTED] Subject: Re: recommended books for web app. Kerry, At 08:09 AM 8/12/2004, you wrote: I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a master/detail table relationship. I need to be aware of securing the database and have been told by others that I should look to use PHP. I know my local bookstore has the following publications (based on asking about MySQL PHP) Beginning PHP, Apache MySQL Web Development published by Wrox PHP MySQL written by Larry Ullmen I'd recommend this one first (actually he has 2 books on PHP MySQL, an intro and an advanced version) because it will get you the basics for using PHP and MySQL. You can also finish each one in about a week because it is not that large. PHP MySQL Web Development written by Luke Welling Laura Thomsan Read this book next because it is quite thorough and will take some time to get through. Mike -- 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]
recommended books for web app.
I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a master/detail table relationship. I need to be aware of securing the database and have been told by others that I should look to use PHP. I know my local bookstore has the following publications (based on asking about MySQL PHP) Beginning PHP, Apache MySQL Web Development published by Wrox PHP MySQL written by Larry Ullmen PHP MySQL Web Development written by Luke Welling Laura Thomsan Has anyone seen these books and possibly recommend one of them? Thanks Kerry
Re: recommended books for web app.
Welling Thomson is terrific. - Original Message - From: Kerry Frater To: MySQL List Sent: Thursday, August 12, 2004 8:09 AM Subject: recommended books for web app. I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a master/detail table relationship. I need to be aware of securing the database and have been told by others that I should look to use PHP. I know my local bookstore has the following publications (based on asking about MySQL PHP) Beginning PHP, Apache MySQL Web Development published by Wrox PHP MySQL written by Larry Ullmen PHP MySQL Web Development written by Luke Welling Laura Thomsan Has anyone seen these books and possibly recommend one of them? Thanks Kerry
RE: recommended books for web app.
Thanks for your recommendation Peter Kerry -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 14:23 To: Kerry Frater; MySQL List Subject: Re: recommended books for web app. Welling Thomson is terrific. - Original Message - From: Kerry Frater To: MySQL List Sent: Thursday, August 12, 2004 8:09 AM Subject: recommended books for web app. I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a master/detail table relationship. I need to be aware of securing the database and have been told by others that I should look to use PHP. I know my local bookstore has the following publications (based on asking about MySQL PHP) Beginning PHP, Apache MySQL Web Development published by Wrox PHP MySQL written by Larry Ullmen PHP MySQL Web Development written by Luke Welling Laura Thomsan Has anyone seen these books and possibly recommend one of them? Thanks Kerry
AW: recommended books for web app.
It's not one from your list but I can recommend you this one: http://www.oreilly.com/catalog/webdbapps2/index.html Gives you a nice overview about PHP/MySQL and a nice case study which explains how to create a Online Winestore. Regards Olivier -Ursprüngliche Nachricht- Von: Peter Brawley [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 12. August 2004 15:23 An: Kerry Frater; MySQL List Betreff: Re: recommended books for web app. Welling Thomson is terrific. - Original Message - From: Kerry Frater To: MySQL List Sent: Thursday, August 12, 2004 8:09 AM Subject: recommended books for web app. I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a master/detail table relationship. I need to be aware of securing the database and have been told by others that I should look to use PHP. I know my local bookstore has the following publications (based on asking about MySQL PHP) Beginning PHP, Apache MySQL Web Development published by Wrox PHP MySQL written by Larry Ullmen PHP MySQL Web Development written by Luke Welling Laura Thomsan Has anyone seen these books and possibly recommend one of them? Thanks Kerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recommended books for web app.
I'd go along with that recommendation. Terry - Original Message - Welling Thomson is terrific. - Original Message - From: Kerry Frater To: MySQL List Sent: Thursday, August 12, 2004 8:09 AM Subject: recommended books for web app. I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a master/detail table relationship. I need to be aware of securing the database and have been told by others that I should look to use PHP. I know my local bookstore has the following publications (based on asking about MySQL PHP) Beginning PHP, Apache MySQL Web Development published by Wrox PHP MySQL written by Larry Ullmen PHP MySQL Web Development written by Luke Welling Laura Thomsan Has anyone seen these books and possibly recommend one of them? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
books about mysql tuning
Hi, I would like to study about how to tuning mysql for the best performance. I am looking for any books about it, so I can study about it offline. I am looking forward to a favorable reply from you. Thank you. Regards, Eko Budiharto
Re: books about mysql tuning
I've just made it through the MySQL Certification Study Guide and have found it to have pretty good coverage of tuning as well as other subjects. There are probably more in-depth sources available, but it might be a good place to start. - Dan-o On Aug 9, 2004, at 12:42 AM, Eko Budiharto wrote: Hi, I would like to study about how to tuning mysql for the best performance. I am looking for any books about it, so I can study about it offline. I am looking forward to a favorable reply from you. Thank you. Regards, Eko Budiharto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: books about mysql tuning
You may want to take a look at High Performance MySQL by Jeremy D. Zawodny and Derek J. Balling (http://www.oreilly.com/catalog/hpmysql). - glenn On Aug 9, 2004, at 10:42 AM, Eko Budiharto wrote: Hi, I would like to study about how to tuning mysql for the best performance. I am looking for any books about it, so I can study about it offline. I am looking forward to a favorable reply from you. Thank you. Regards, Eko Budiharto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: books about mysql tuning
Eko Budiharto [EMAIL PROTECTED] wrote: I would like to study about how to tuning mysql for the best performance. I am looking for any books about it, so I can study about it offline. I am looking forward to a favorable reply from you. Thank you.=20 High Performance MySQL by Jeremy Zawodny is definitely a first choice. :) See http://www.highperformancemysql.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recommendation on god MySQL books
I really like the Certification Study Guide we just ordered last week. Great info that I'd wish I had when I started. I have no plans to take the test, but I love the way the info is presented and the questions at the end help ensure I got it. Lou - Original Message - From: Bartis, Robert M (Bob) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:44 PM Subject: Recommendation on god MySQL books I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to stay away from? Thanks in advance Bob -- 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]
Recommendation on god MySQL books
I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to stay away from? Thanks in advance Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Recommendation on god MySQL books
I think Wiley´s Mysql enterprise solutions could be a good option. It´s a great book and have an entire chapter covering replication -Mensaje original- De: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 17 de Junio de 2004 11:44 a.m. Para: [EMAIL PROTECTED] Asunto: Recommendation on god MySQL books I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to stay away from? Thanks in advance Bob -- 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: Recommendation on god MySQL books
God doesn't use MySQL (I think he leans towards Postgres - he needs views and triggers). But if you are interested in MySQL, Paul DuBois's book, MySQL, Second Edition is a great reference. If you need more insight into performance tuning, then Jeremy Zawodny and Derek Balling's book, High Performance MySQL, can be very helpful. Both are up to date. David Bartis, Robert M (Bob) wrote: I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to stay away from? Thanks in advance Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recommendation on god MySQL books
When I first started, I bought MySQL by Paul DuBois. It covers the basics to admin responsibilities and preventive maintenance. But, you may want to search the archives, this question has been asked many times before. On Jun 17, 2004, at 1:44 PM, Bartis, Robert M (Bob) wrote: I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to stay away from? Thanks in advance Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recommendation on god MySQL books
Get the recently published book from Jeremy Zawodny. It's excellent. Very easy to understand and goes through all the admin stuff. It has a chapter dedicated to replication and explains in simple concise steps how to set up replication. It demonstrates many different types of replication configurations from simple master-slave to multi-master/multi-slave configurations. It also has excellent material on backup strategies and much more. The book is called High Performance MySQL and published by O'Reilly . really great book. I bought mine on Amazon. It is aimed at intermediate to advanced users. Read the Amazon comments and feedback for more details. -Kieran Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL 4.0.20 / Connector-J 3.0.11 Blog: http://webobjects.webhop.org/ On Jun 17, 2004, at 1:44 PM, Bartis, Robert M (Bob) wrote: I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to stay away from? Thanks in advance Bob -- 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]
Books High Performance MySQL and Server Load Balancing
Hi All, I'm reading High Performance MySQL. In my humble opinion is an very good book. Congratulations to the authors. In the chapter Load Balancing and High Availability is cited the Tony Bourke's book Server Load Balancing. Someone read it? is one good reference font? I need study this subject. Any other recommendation? Thanks in advance. Renato Cramer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books advice
At 21:04 -0400 7/31/03, Asif Iqbal wrote: I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois Comparison information: http://www.kitebird.com/mysql-book-comparison.php This page also includes links to each book's home page that provides other information about the book such as ISBN. On Thu, 31 Jul 2003, Ralph Guzman wrote: Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books advice
Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff +---+ | Jeffery C Baldwin | Computer Consultant II | | University of North Carolina - Chapel Hill | 213 Miller Hall | CB# 1105 | Chapel Hill, NC 27599 | | Phone: (919) 843-2725 | Fax: (919) 966-8928 | E-Mail: jeff_baldwin at unc dot edu +---+ -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:02 PM To: Asif Iqbal; Ralph Guzman Cc: 'Fawad Siddiqui'; [EMAIL PROTECTED] Subject: RE: Books advice At 21:04 -0400 7/31/03, Asif Iqbal wrote: I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois Comparison information: http://www.kitebird.com/mysql-book-comparison.php This page also includes links to each book's home page that provides other information about the book such as ISBN. On Thu, 31 Jul 2003, Ralph Guzman wrote: Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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: Books advice
At 12:14 -0400 8/4/03, Jeffery C. Baldwin wrote: Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Thanks, I hope you find it helpful. I agree that it would be nice were the book a bit shorter. If there is a third edition, I will probably trim the 3.22/3.23 material to an appendix or web-accessible-only addendum and make 4.0 the baseline version to keep the size down. :-) Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff +---+ | Jeffery C Baldwin | Computer Consultant II | | University of North Carolina - Chapel Hill | 213 Miller Hall | CB# 1105 | Chapel Hill, NC 27599 | | Phone: (919) 843-2725 | Fax: (919) 966-8928 | E-Mail: jeff_baldwin at unc dot edu +---+ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RE: Books advice
Paul's book is long, but like good code, it's modular, so the length isn't an issue. From: Jeffery C. Baldwin [EMAIL PROTECTED] Date: 2003/08/04 Mon AM 11:14:29 CDT To: 'Paul DuBois' [EMAIL PROTECTED], 'Asif Iqbal' [EMAIL PROTECTED], 'Ralph Guzman' [EMAIL PROTECTED] CC: 'Fawad Siddiqui' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Books advice Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff +---+ | Jeffery C Baldwin | Computer Consultant II | | University of North Carolina - Chapel Hill | 213 Miller Hall | CB# 1105 | Chapel Hill, NC 27599 | | Phone: (919) 843-2725 | Fax: (919) 966-8928 | E-Mail: jeff_baldwin at unc dot edu +---+ -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:02 PM To: Asif Iqbal; Ralph Guzman Cc: 'Fawad Siddiqui'; [EMAIL PROTECTED] Subject: RE: Books advice At 21:04 -0400 7/31/03, Asif Iqbal wrote: I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois Comparison information: http://www.kitebird.com/mysql-book-comparison.php This page also includes links to each book's home page that provides other information about the book such as ISBN. On Thu, 31 Jul 2003, Ralph Guzman wrote: Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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]
books advice
Dear all, Thank you very much for all your responses. I have settled on the at least one book, SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas. I would, however, ask Paul to recommend one from his list of numerous titles, that he feels would give me the best possible entry in to the wonders of MySQL. Rest assured Paul I would like to reach an administrative level understanding of MySQL, with options of programming in the future. Hope this helps in deciding a title. Many thanks people, and to Paul in advance for his attention. Sincerely, Fawad
Re: books advice
At 21:47 +0100 8/4/03, Fawad Siddiqui wrote: Dear all, Thank you very much for all your responses. I have settled on the at least one book, SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas. I would, however, ask Paul to recommend one from his list of numerous titles, that he feels would give me the best possible entry in to the wonders of MySQL. Rest assured Paul I would like to reach an administrative level understanding of MySQL, with options of programming in the future. Hope this helps in deciding a title. For those purposes, I would recommend: MySQL, Second Edition http://www.kitebird.com/mysql-book/ Many thanks people, and to Paul in advance for his attention. Sincerely, Fawad -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Books advice
Jeff, thanks for our .02. I'm about done with my second SQL book so after reading your words the company just bought mePauls Mysql book. Thanks for your opinion. SJohnson On Mon, 4 Aug 2003 12:14:29 -0400 Jeffery C. Baldwin wrote: Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a hard copy of the 2nd edition of this book.. well.. I ended up leaving the store with a copy of 'Mastering MySQL' by Sybex instead. I returned that book yesterday and picked up the 2nd Edition of MySQL :-). I initially chose the 'Mastering MySQL' book pretty much due to one reason, and that the size of the MySQL' book was a little intimidating. But once I got home and started reading the Sybex book I realized why Pauls' book is so long, it is impossible to cover the amount of content necessary to get a good grasp for Mysql without using a lot of paper :-). The Sybex book made a lot of assumptions and didn't go into what I felt was very thorough detail on any subject (my idea is that this is a great book for the experienced DB admin), while Paul takes the time to explain each subject and every detail very thoroughly. Thanks Paul, I just started this book but I'm already very impressed. Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Books advice
It depends on what you want to know. I used _Fundamentals of Database Systems_ (Elmasri and Navathe) when I took a DB course. It was pretty good, though my impression is that there might be a classic which is better. The problem with the more MySQL-specific books is that you might not learn the more abstract aspects of database design. E.g. some MySQL literature seems to imply that keys and indexes are the same thing, which is not true. Also, a book like the one above will strongly emphasize what an ideal RDMS will adhere to, most importantly data integrity, especially referential integrity. Earlier editions of MySQL (including the one I'm using) don't actually enforce foreign key references. And judging from some things I see posted in this list, your DB design will be well-served by learning the fundamentals. I haven't read Celko's books, but my guess is that they're advanced, not foundational, and that you'd be better served by first looking at a foundational book. -S - Original Message - From: Fawad Siddiqui [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 31, 2003 8:05 PM Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Books advice
Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad
RE: Books advice
Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Books advice
Hi I guess I will plug Paul's books. I have his MySQL book and his MySQL and Perl for the Web. I really enjoyed the second one but the MySQL book was very well written. I also have read Sam's teach yourself MySQL in 21 days which seemed pretty light weight and I never look up anything in it. I also have the MySQL reference manual which is great for really technical type questions. Mike - Original Message - From: Ralph Guzman [EMAIL PROTECTED] To: 'Fawad Siddiqui' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: July 31, 2003 8:23 PM Subject: RE: Books advice Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- 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: Books advice
I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois On Thu, 31 Jul 2003, Ralph Guzman wrote: Here are two other books that I would recommend, specially the first one: * SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas Joe Celko's SQL for Smarties: Advanced SQL Programming by Joe Celko -Original Message- From: Fawad Siddiqui [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Books advice Hi, I would like to learn about RDBMS, namely mysql of course, but know really nothing in this area, so have to learn about; RDBMS, SQL and mysql from scratch. In this regard, if anyone knows of any books they think would start me off on the right foot, I would be very grateful. I have done some searching on Amazon, with the following results. 1.Beginning Databases with MySQL by Richard Stones, Neil Matthew 2.MySQL Cookbook by Paul DuBois 3.Managing and Using MySQL by George Reese, et al 4.Inside Relational Databases by Mark Whitehorn, Bill Marklyn 5.Database Design by Ryan K. Stephens, Ronald R. Plew 6.The Practical SQL Handbook: Using SQL Variants by Judith S. Bowman, et al Many thanks in advance for all your help. Fawad -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books advice
Asif, can you paste here the ISBN? Thanks!! Lucas -Mensaje original- De: Asif Iqbal Enviado el: Jueves, 31 de Julio de 2003 22:05 Para: Ralph Guzman CC: 'Fawad Siddiqui'; [EMAIL PROTECTED] Asunto: RE: Books advice I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Books advice
ISBN 0-7357-1212-3 On Fri, 1 Aug 2003, Lucas Fonzalida - Soporte Tecnico wrote: Asif, can you paste here the ISBN? Thanks!! Lucas -Mensaje original- De: Asif Iqbal Enviado el: Jueves, 31 de Julio de 2003 22:05 Para: Ralph Guzman CC: 'Fawad Siddiqui'; [EMAIL PROTECTED] Asunto: RE: Books advice I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Paul, do you address this in any of your books?
I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? If mysql can't handle this with sql only, would it be able to do it once subselects or other features are available in future releases? Anyone used postgresql? I wonder if it could handle it. Any thoughts? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Paul, do you address this in any of your books?
Hi, You can try to use IF(),CASE() function in the SQL statement. Eg. select USERID,IF(DAY='2003-01-02',COUNT(*),0) as 2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where YOUR_CONDITIONS GROUP BY DAY; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: DANIEL GADDIS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:40 PM Subject: Paul, do you address this in any of your books? I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? If mysql can't handle this with sql only, would it be able to do it once subselects or other features are available in future releases? Anyone used postgresql? I wonder if it could handle it. Any thoughts? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Paul, do you address this in any of your books?
i correct my example : select USERID,IF(DAY='2003-01-02',SUM(LIS_QUANTITY),0) as 2003-01-02,IF(DAY='2003-01-03',SUM(LIS_QUANTITY),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where YOUR_CONDITIONS GROUP BY DAY; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: DANIEL GADDIS [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 14, 2003 11:05 PM Subject: Re: Paul, do you address this in any of your books? Hi, You can try to use IF(),CASE() function in the SQL statement. Eg. select USERID,IF(DAY='2003-01-02',COUNT(*),0) as 2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where YOUR_CONDITIONS GROUP BY DAY; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: DANIEL GADDIS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:40 PM Subject: Paul, do you address this in any of your books? I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? If mysql can't handle this with sql only, would it be able to do it once subselects or other features are available in future releases? Anyone used postgresql? I wonder if it could handle it. Any thoughts? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Paul, do you address this in any of your books?
At 14:40 -0600 3/14/03, DANIEL GADDIS wrote: I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? If mysql can't handle this with sql only, would it be able to do it once subselects or other features are available in future releases? Anyone used postgresql? I wonder if it could handle it. Any thoughts? Thanks, Daniel Actually, if I remember correctly, I don't cover this anywhere. I recommend reading the cross-tabulation article on mysql.com that an earlier response referred to. -- Paul DuBois, [EMAIL PROTECTED] http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Paul, do you address this in any of your books?
this article on cross tabulations should help you ... http://www.mysql.com/articles/wizard/index.html - hcir (mysql sql query) On Friday, Mar 14, 2003, at 11:40 America/Anchorage, DANIEL GADDIS wrote: I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What are the best MySQL and PHP resource books?
Thanks again to everyone who replied! I finally decided on: MySQL - Second Edition Professional PHP Programming - Second Edition After all the responses here and the feedback through the online bookstores, those are what I'm after. -- Loren McDonald [EMAIL PROTECTED] -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 01, 2003 5:16 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: What are the best MySQL and PHP resource books? HI Before I just go out and buy, I wanted to get some opinions / advice on what you all think the best MySQL and PHP resource books are. I am not web design illiterate (have HTML and Perl experience), but I havent the first clue about PHP and using MySQL with it. In other words, I am NOT looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know. Thanks in advance to all who reply! -- Loren McDonald [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What are the best MySQL and PHP resource books?
Well, like others, I reccomend MySQL by Paul Dubois. It is my only MySQL book besides the copy of the MySQL reference manual provided by work. I have an associate that has PHP and MySQL web development by Sams, and it gives my any references I need for PHP. Looks like it is being updated on the 13th of Feb, so maybe wait for the next edition which I assume will cover the latest versions of both. Mike Hillyer -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 1:30 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: What are the best MySQL and PHP resource books? HI Before I just go out and buy, I wanted to get some opinions / advice on what you all think the best MySQL and PHP resource books are. I am not web design illiterate (have HTML and Perl experience), but I havent the first clue about PHP and using MySQL with it. In other words, I am NOT looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know. Thanks in advance to all who reply! -- Loren McDonald [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What are the best MySQL and PHP resource books?
HI Before I just go out and buy, I wanted to get some opinions / advice on what you all think the best MySQL and PHP resource books are. I am not web design illiterate (have HTML and Perl experience), but I havent the first clue about PHP and using MySQL with it. In other words, I am NOT looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know. Thanks in advance to all who reply! -- Loren McDonald [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What are the best MySQL and PHP resource books?
HI Before I just go out and buy, I wanted to get some opinions / advice on what you all think the best MySQL and PHP resource books are. I am not web design illiterate (have HTML and Perl experience), but I havent the first clue about PHP and using MySQL with it. In other words, I am NOT looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know. Thanks in advance to all who reply! -- Loren McDonald [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What are the best MySQL and PHP resource books?
Hi Loren, I recomend to take a look at these books: -MySQL , Paul DuBois -PHP 4, the bible 2nd edition, Converse, Park Best regards, Davy Obdam mailto:[EMAIL PROTECTED] Loren McDonald wrote: HI Before I just go out and buy, I wanted to get some opinions / advice on what you all think the best MySQL and PHP resource books are. I am not web design illiterate (have HTML and Perl experience), but I havent the first clue about PHP and using MySQL with it. In other words, I am NOT looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know. Thanks in advance to all who reply! -- Davy Obdam - Obdam webdesign© mailto:[EMAIL PROTECTED] web: www.davyobdam.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What are the best MySQL and PHP resource books?
Hi Loren, THE book on MySQL is MySQL, by Paul DuBois. It's published by New Riders. They just came out with an updated version. The PHP book I have, which I would definitely recommend, is Professional PHP Programming, with several authors, published by Wrox press. They don't focus on IIS, rather they assume Apache, but beyond the initial setup and configuration I don't think it matters. -Lisi At 05:16 PM 2/1/03 -0500, Loren McDonald wrote: HI Before I just go out and buy, I wanted to get some opinions / advice on what you all think the best MySQL and PHP resource books are. I am not web design illiterate (have HTML and Perl experience), but I haven't the first clue about PHP and using MySQL with it. In other words, I am NOT looking for basic step by step books, but ones that have good, working examples, are formatted so to make finding things fairly simple, and also make note of Windows (IIS) specifics that I may need to know. Thanks in advance to all who reply! -- Loren McDonald [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What are the best MySQL and PHP resource books?
Hi, Loren - I'd first go with any book from O'Reilly (http://www.ora.com) After that, I've found Welling and Thomson's PHP and MySQL Web Development pretty good. http://www.sams.com A couple of my students liked: Meloni's Teach Yourself PHP, MySQL and Apache in 24 Hours, also at Sams (part of why they liked it was the MUCH lower price, I suspect!) HTH. vh -- \ / Virginia R. Hetrick, here in sunny California 0 Voicemail: 310.471.1766 Email: [EMAIL PROTECTED] Oo There is always hope. My health site: http://www.yana.org/hetrick Site of the month: http://www.washington.edu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie stuff: good mysql books?
Greets Folks, I have been wanting to get into data driven sites for the longest time, and I can do some immediate level work in them using perl, but my understanding is still not comprehensive enough for whatever it is I want to do (subconsciously). I sense there is some need to pursue database design better, and an overall book on system's design might be good too. I've read MySQL and Perl for the Web by Paul, and Programming with CGI.pm, and both helped a lot. But there is some sort of a want to work specifically with the database more, especially design for largescale systems development, and I am just wondering what books might be good for this purpose? PLMK, Thanks, Will _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Recommended Books
Hi, Any anyone have recommendations on MySql books currently in print. What's the best or is the online manual all that's needed ! Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Recommended Books
For now, Joe Celko, SQL for Smarties. But stay tuned :-). - - Original Message - From: Curley, Thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 07, 2002 5:28 AM Subject: Recommended Books Hi, Any anyone have recommendations on MySql books currently in print. What's the best or is the online manual all that's needed ! Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Recommended Books
Actually, I'd suggest the New Riders Book by Paul DuBois, Mysql...what was it you wanted to achieve with your book: * do you want a reference * a tutorial ...? mysql,query DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Recommended Books
Hi Thomas, This is Tarun Khandelwal from Jaipur, Rajasthan, INDIA !!! 'N' I hav also bought a book on MySQL whose name is: MySQL by Paul DuBios ( Forwarded by Michael Monty Widenius,MySQL Moderator) This all is written on the book 'n' it one of the best book available. There is also a book of Oriely. U can check it's price 'n' other views on www.amazon.com ( on the books section ) These books will be available. Awaiting your earliest reply the cyberwiz Tarun Khandelwal Jaipur [EMAIL PROTECTED] [EMAIL PROTECTED] MSN messenger Id: [EMAIL PROTECTED] - Original Message - From: Curley, Thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 07, 2002 5:58 PM Subject: Recommended Books Hi, Any anyone have recommendations on MySql books currently in print. What's the best or is the online manual all that's needed ! Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: spanish books about mysql?
Well, I bought MySQL, Edición Especial from Paul DuBois. The editor is Prentice Hall. Maybe you can buy it at www.pearsoneducacion.com... jeje I found one about MySQL and Perl there. - Original Message - From: Markus Jais [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 24, 2002 5:01 AM Subject: spanish books about mysql? hello I searched amazon.com for spanish books about mysql or postgresql but I couldn't find anything. and there is no amazon.es. does anybody know if there is a online shop where I can search for spanish books about mysql??? thanks in advance markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: spanish books about mysql?
Are there any mysql books in Latin? Me sequelae datorum ordinatrum, scribo Paulus ExSilvaticus - when you write the rest yourself you may find the following useful/entertaining Vocabula computatralia Vocabula computatralia. A. abort 1. vt interrumpere 2. subst. interruptus,us m. address 1. (memory location) subst. locus (memoriae ... Description: Vocabulario anglico-latino Draconis editio secunda, anno MCMXCIX. Category: World Lingua Latina Computatra www.obta.uw.edu.pl/~draco/docs/voccomp.html - 21k - Cached - Similar pages Regards, =dn At 11:01 +0200 8/24/02, Markus Jais wrote: hello I searched amazon.com for spanish books about mysql or postgresql but I couldn't find anything. and there is no amazon.es. does anybody know if there is a online shop where I can search for spanish books about mysql??? I don't know of a shop, but I know of at least one MySQL book that is available in Spanish: http://www.kitebird.com/mysql-book/translations.php thanks in advance markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB books
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 March 2002 07:59 To: Sean O'Donnell Subject: Re: InnoDB books Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: does anyone know of any books that give innodb good coverage? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB books
Core MySQL ISBN: 0130661902 http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?isbn=0130661902 [EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 March 2002 07:59 To: Sean O'Donnell Subject: Re: InnoDB books Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: does anyone know of any books that give innodb good coverage? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB books
Sean, since InnoDB development progresses rapidly, no book except the InnoDB online manual is fully up-to-date. The page http://www.innodb.com/books.html contains a link to Michael Kofler's MySQL book which treats InnoDB and BDB in appendixes. There is also a link to a recent Terra Lycos Webmonkey online article by Jay Greenspan about transactions in MySQL. I have not seen a copy of 'Core Mysql' by Leon Atkinson. Therefore I do not know how comprehensive the InnoDB coverage is in that book. From the contents I see there is a chapter on transactions in MySQL. Since the most important aspect in InnoDB is transactions and multiversion concurrency control, and those are close to Oracle, some general SQL books which are aware of Oracle might also help. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Gabriel Ricard [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Monday, March 25, 2002 7:12 PM Subject: Re: InnoDB books Core MySQL ISBN: 0130661902 http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?isbn=0130661902 [EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 March 2002 07:59 To: Sean O'Donnell Subject: Re: InnoDB books Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: does anyone know of any books that give innodb good coverage? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to get books/manuals from Internet.
At 14:20 +0800 3/1/02, [EMAIL PROTECTED] wrote: Hi, all How to get the e-books of My SQL via download. Thanks , Dominic ZHOU The MySQL Reference Manual is available at: http://www.mysql.com/ Safari has some MySQL books: http://safari.oreilly.com/ The listings include MySQL (New Riders) and MySQL mSQL (O'Reilly). I got a letter yesterday that MySQL and Perl for the Web will be available there soon as well. Safari's a subscriber service. If you're looking for chapters that you can download anytime, pointers to a few are available at: http://www.kitebird.com/mysql-book/ (1 chapter) http://www.kitebird.com/mysql-perl/ (2 chapters) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to get books/manuals from Internet.
Hi, all How to get the e-books of My SQL via download. Thanks , Dominic ZHOU - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Books
Paul's book on MYSQL, and the Wroc book on PHP... and you'll be good to go. On Thu, 12 Apr 2001 21:51:53 -0600, Mike wrote: I am looking at using MySQL,Apache and PHP on a Web app and was wondering if there was a good book out there. I seen a few on the MySQL site that look really interesting, any comments on them. Cheers Mike Benzel [EMAIL PROTECTED] Code it once with ASTA and run it anywhere Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE) ASTA Technology Group http://www.astatech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Books
I am looking at using MySQL,Apache and PHP on a Web app and was wondering if there was a good book out there. I seen a few on the MySQL site that look really interesting, any comments on them. Cheers Mike Benzel [EMAIL PROTECTED] Code it once with ASTA and run it anywhere Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE) ASTA Technology Group http://www.astatech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL books
The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois' book, and now I only use the command reference at the back of the O'Reilly book for quick lookups. I like the way it is layed out. Every other question relating to MySQL has been answered by Paul's book. On 3/28/01 1:28 PM, "[EMAIL PROTECTED]" [EMAIL PROTECTED] wrote: Speaking of books on MySQL are there more than one to choose from? If so is MySQL written by Paul DuBois the best one? John Jackson Direct Access Recruiters [EMAIL PROTECTED] -Original Message- From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:03 AM To: [EMAIL PROTECTED] Subject: Re: Betr.: Hello ...And.. a book called MySQL written by Paul DuBois. It's a great book and will help you to get things up and running within a very short time.. It will cost you another 2-3 days (based on 8 hours per day) to work your way through the book and all the examples.. but you will know most of the basics.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL books
I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? John Jackson [EMAIL PROTECTED] -Original Message- From: Lindsay Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 7:29 PM To: [EMAIL PROTECTED] Subject: Re: MySQL books The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois' book, and now I only use the command reference at the back of the O'Reilly book for quick lookups. I like the way it is layed out. Every other question relating to MySQL has been answered by Paul's book. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL books
I got the PaulDubois book , but i made a mistake i bought the transaltion in french. An advice to all others who are thinking of buying it in french if you can buy it in englis , Yann - Original Message - From: [EMAIL PROTECTED] To: "Lindsay Adams" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 11:22 PM Subject: RE: MySQL books I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? John Jackson [EMAIL PROTECTED] -Original Message- From: Lindsay Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 7:29 PM To: [EMAIL PROTECTED] Subject: Re: MySQL books The O'Reilly MySQL msql book is not bad, but then I bought Paul DuBois' book, and now I only use the command reference at the back of the O'Reilly book for quick lookups. I like the way it is layed out. Every other question relating to MySQL has been answered by Paul's book. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL books
I was at the store tonight. Did not see an O'Reilly book but believe I saw the book by Paul DuBois. There was also a book, one of the Teach Yourself (MySQL) in 21 Days, series. Anybody familiar with that one? I would go for Paul's book (he should pay me for everytime I refer to his book :)) If you're starting with MySQL his book is great, explains how to connect with MySQL from C, Perl and PHP. Wouldn't miss the O'Reilly book though. I'm not familiar with the Teach Yourself MySQL book. Paul's book took me 2 days.. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php