Re: MySQL book
Gerald Taylor wrote: I totally recommend Paul Dubois's book. Excellent book I own the first edition. I bet the second edition is just as good and more up to date. Paul DuBois wrote: At 1:55 +0200 7/26/04, Schalk Neethling wrote: Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois http://www.informit.com/safari/author_bio.asp?ISBN=0735709211 - New Riders Publishing That's the first edition. I would suggest getting the second edition instead. :-) (http://www.kitebird.com/mysql-book/) I have both and the second edition is even better than the first. Highly recommended. -- Rory McKinley Nebula Solutions +27 21 555 3227 - office +27 21 551 0676 - fax +27 82 857 2391 - mobile www.nebula.co.za This e-mail is intended only for the person to whom it is addressed and may contain confidential information which may be legally privileged. Nebula Solutions accepts no liability for any loss, expense or damage arising from this e-mail and/or any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL book
I totally recommend Paul Dubois's book. Excellent book I own the first edition. I bet the second edition is just as good and more up to date. Paul DuBois wrote: At 1:55 +0200 7/26/04, Schalk Neethling wrote: Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois http://www.informit.com/safari/author_bio.asp?ISBN=0735709211 - New Riders Publishing That's the first edition. I would suggest getting the second edition instead. :-) (http://www.kitebird.com/mysql-book/) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL book
Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois http://www.informit.com/safari/author_bio.asp?ISBN=0735709211 - New Riders Publishing -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL book
At 1:55 +0200 7/26/04, Schalk Neethling wrote: Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois http://www.informit.com/safari/author_bio.asp?ISBN=0735709211 - New Riders Publishing That's the first edition. I would suggest getting the second edition instead. :-) (http://www.kitebird.com/mysql-book/) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which is the best MySQL book?
Is there one that's especially outstanding? Thanks, jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] Which is the best MySQL book?
On Thu, Oct 09, 2003 at 03:03:59PM -0400, Anderson, James H [IT] wrote: Is there one that's especially outstanding? I haven't read it front to back, but I have an affinity for New Rider's MySQL by Paul DuBois. (It's where I picked up PHP, and has been a useful reference for me these days, as I work as a newbie MySQL coder :^) ) I've also got O'Reilly's MySQL Cookbook (also by DuBois) sitting here on my desk, and have found it useful to get some real-world questions answered quickly. 'course, I'm working at a tech. book store right now, so I'll no doubt start poking my nose in the dozen other titles we have sitting on the shelf here. :^) -bill! -- [EMAIL PROTECTED] Got kids? Get Tux Paint! http://newbreedsoftware.com/bill/ http://newbreedsoftware.com/tuxpaint/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Which is the best MySQL book?
MySQL the definitive guide to using, programming, and administering mySQL, version 2 by Paul Dubois, who is active on this list. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] --Sent: Thursday, October 09, 2003 12:04 PM --To: [EMAIL PROTECTED] --Subject: Which is the best MySQL book? -- --Is there one that's especially outstanding? -- --Thanks, -- --jim -- --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: Which is the best MySQL book?
At 02:03 PM 10/9/2003, you wrote: Is there one that's especially outstanding? Thanks, jim -- Jim, MySQL Cookbook also by Paul Dubois is also a good read. I got both books (including MySQL 2nd Edition) at a 30% discount off the list price plus another $10 off with a coupon plus free shipping. So don't pay retail (unless you have plenty of $$). I got one book from Amazon and the other from Chapters. You need to search around for a coupon site and you'll usually find a $10 off coupon that can be applied to each bookstore. Since there was free shipping it didn't cost me anything to order it from 2 different locations. If they were any cheaper, Paul would have to pay me to take them.vbg Mike (el cheapo) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Which is the best MySQL book?
Cheap books - http://www.bookpool.com -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 4:16 PM To: Anderson, James H [IT] Cc: [EMAIL PROTECTED] Subject: Re: Which is the best MySQL book? At 02:03 PM 10/9/2003, you wrote: Is there one that's especially outstanding? Thanks, jim -- Jim, MySQL Cookbook also by Paul Dubois is also a good read. I got both books (including MySQL 2nd Edition) at a 30% discount off the list price plus another $10 off with a coupon plus free shipping. So don't pay retail (unless you have plenty of $$). I got one book from Amazon and the other from Chapters. You need to search around for a coupon site and you'll usually find a $10 off coupon that can be applied to each bookstore. Since there was free shipping it didn't cost me anything to order it from 2 different locations. If they were any cheaper, Paul would have to pay me to take them.vbg Mike (el cheapo) -- 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 book TOC
On Sat, Feb 08, 2003 at 10:47:55PM -0800, Nasser Ossareh wrote: SQL in the What is SQL? phrase threw me... I thought you were talking about MS SQL.. SQL is and should be known as a query language, not a product. It should be perhaps clarified the first time it is used as not refering to the Microsoft SQL Server product often mis- named as 'SQL' itself (by people who don't know what SQL is). If I were you, I would explain relational databases and normalization (at list to normal form III). Very well described by many other books; especially Oracle certification books. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - 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 book TOC
On Fri, Feb 07, 2003 at 03:20:47PM +0500, Vikram Vaswani wrote: My name is Vikram Vaswani, and I'm currently working on the outline for a MySQL reference book. This is supposed to be a comprehensive reference to MySQL 4, covering all aspects of the software, including the new transaction/subquery features. Call me biased, but that and this... Since I'm not that experienced with MySQL Don't seem like the right combination. Did you mean not that experienced writing about MySQL? Or are you really new to MySQL and trying to write a book about it? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 5 days, processed 185,500,832 queries (392/sec. avg) - 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 book TOC
On 2/7/03 2:20 AM, Vikram Vaswani [EMAIL PROTECTED] wrote: Hello all, My name is Vikram Vaswani, and I'm currently working on the outline for a MySQL reference book. This is supposed to be a comprehensive reference to MySQL 4, covering all aspects of the software, including the new transaction/subquery features. I have put together a draft table of contents (TOC), but am a little hesitant about some aspects of it. I have a nagging feeling that I'm missing out on a lot of things here, and also that it might bs structured better. Specifically, I was hoping that this list would help me in evaluating the structure and content of Section 2 below. Since I'm not that experienced with MySQL, I thought I'd open this up to the list and see if you guys could help me figure out what's bugging me :) I'd appreciate as much feedback as possible, since my aim here is to produce something that would hopefully be useful to you in your usage of MySQL (and also stand out from the crowd of other MySQL books in the market) Thanks! I look forward to hearing back. Vikram Vaswani Maybe you come a little bit late: First there is an excellent manual out (referenced in every list message footer - and now even in print) and on top of that we already have the great books from Paul DeBois. http://www.kitebird.com/ http://www.mysql.com/doc/en/index.html I would strongly recommend that you check out both sources before you start writing. It might well be that topics such as subselects and other advanced features are not as well covered since they will be introduced in V 4.1 but still there is plenty of general SQL books out here already. But in any case I am as a single person don't define the market anyway thus lets hear what others have to say. You certainly came to the right place to find out. Best/h - 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 book TOC
my 2 cents: SQL in the What is SQL? phrase threw me... I thought you were talking about MS SQL.. If I were you, I would explain relational databases and normalization (at list to normal form III). Usage?? well whoever goes to buy your book, must have some ideas in head for the usage.. I don't think you should waste trees on telling people things that don't help them. One Question: What makes this book different from the MySQL manual? Another Question: Who is your intended audience? A suggestion: Think of substantial examples How about performance? and Performance tuning? Good luck --- Vikram Vaswani [EMAIL PROTECTED] wrote: Hello all, My name is Vikram Vaswani, and I'm currently working on the outline for a MySQL reference book. This is supposed to be a comprehensive reference to MySQL 4, covering all aspects of the software, including the new transaction/subquery features. I have put together a draft table of contents (TOC), but am a little hesitant about some aspects of it. I have a nagging feeling that I'm missing out on a lot of things here, and also that it might bs structured better. Specifically, I was hoping that this list would help me in evaluating the structure and content of Section 2 below. Since I'm not that experienced with MySQL, I thought I'd open this up to the list and see if you guys could help me figure out what's bugging me :) I'd appreciate as much feedback as possible, since my aim here is to produce something that would hopefully be useful to you in your usage of MySQL (and also stand out from the crowd of other MySQL books in the market) Thanks! I look forward to hearing back. Vikram Vaswani -- TOC Section 1: Installation 1.Introduction to MySQL What is MySQL? History Features Future development 2. Installing Linux Windows Section 2: Usage 3.Introduction to Databases and SQL What is SQL? SQL variants SQL features SQL syntax A sample SQL session 4.MySQL Data Types Basic data types String and string variants Integer and integer variants Date and time types Boolean types Null type Advanced data types Enum (choice) type Binary object type 5.MySQL Syntax (Working With Databases) - CREATE, DROP, SHOW Understanding how databases are stored on the file system Creating a database Viewing available databases Deleting a database Do I need to add info on the InnoDB/Berkelet/MyISAM types here? And how/when to select each? 6.MySQL Syntax (Working With Tables) - DESCRIBE, SELECT, INSERT, UPDATE, DELETE, APPEND, joins Understanding how tables are stored on the file system MySQL table types Creating a table Viewing available tables Creating table columns Inserting records Viewing table records Editing (updating) table records Joining tables Erasing records Altering columns Erasing columns Erasing tables What have I missed here? 7.MySQL Syntax (Working With Tables - Advanced) - Indices, transactions and sub-queries Advanced joins Sub-queries Indices Transactions Stored procedures Do you think I need a separate chapter for each of the above? What have I missed here? Section 3: Administration Section 4: Development -- -- Luke: I don't believe it! Yoda: That, is why you fail. --Star Wars: The Empire Strikes Back - 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 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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 book TOC
Jeremy - the first one ;) Any comments on the TOC? Vikram At 02:46 PM 2/8/03 -0800, Jeremy Zawodny wrote: On Fri, Feb 07, 2003 at 03:20:47PM +0500, Vikram Vaswani wrote: My name is Vikram Vaswani, and I'm currently working on the outline for a MySQL reference book. This is supposed to be a comprehensive reference to MySQL 4, covering all aspects of the software, including the new transaction/subquery features. Call me biased, but that and this... Since I'm not that experienced with MySQL Don't seem like the right combination. Did you mean not that experienced writing about MySQL? Or are you really new to MySQL and trying to write a book about it? Jeremy - 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 book TOC
Hi Nasser, Usage?? well whoever goes to buy your book, must have some ideas in head for the usage.. I don't think you should waste trees on telling people things that don't help them. One Question: What makes this book different from the MySQL manual? Well, it's not supposed to replace the manual by any means - it's just supposed to offer novice-intermediate users a starting point to MySQL usage Another Question: Who is your intended audience? Novice to intermediate users A suggestion: Think of substantial examples How about performance? and Performance tuning? I am planning to cover this, but in the latter sections of the book. Fundamentally, my problem is with the Section 2 - I am not sure what level of detail to go to in this section. Any assistance you or other list members could provide would be very helpful :) Thanks for your response, Vikram - 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
MySQL book TOC
Hello all, My name is Vikram Vaswani, and I'm currently working on the outline for a MySQL reference book. This is supposed to be a comprehensive reference to MySQL 4, covering all aspects of the software, including the new transaction/subquery features. I have put together a draft table of contents (TOC), but am a little hesitant about some aspects of it. I have a nagging feeling that I'm missing out on a lot of things here, and also that it might bs structured better. Specifically, I was hoping that this list would help me in evaluating the structure and content of Section 2 below. Since I'm not that experienced with MySQL, I thought I'd open this up to the list and see if you guys could help me figure out what's bugging me :) I'd appreciate as much feedback as possible, since my aim here is to produce something that would hopefully be useful to you in your usage of MySQL (and also stand out from the crowd of other MySQL books in the market) Thanks! I look forward to hearing back. Vikram Vaswani -- TOC Section 1: Installation 1.Introduction to MySQL What is MySQL? History Features Future development 2. Installing Linux Windows Section 2: Usage 3.Introduction to Databases and SQL What is SQL? SQL variants SQL features SQL syntax A sample SQL session 4.MySQL Data Types Basic data types String and string variants Integer and integer variants Date and time types Boolean types Null type Advanced data types Enum (choice) type Binary object type 5.MySQL Syntax (Working With Databases) - CREATE, DROP, SHOW Understanding how databases are stored on the file system Creating a database Viewing available databases Deleting a database Do I need to add info on the InnoDB/Berkelet/MyISAM types here? And how/when to select each? 6.MySQL Syntax (Working With Tables) - DESCRIBE, SELECT, INSERT, UPDATE, DELETE, APPEND, joins Understanding how tables are stored on the file system MySQL table types Creating a table Viewing available tables Creating table columns Inserting records Viewing table records Editing (updating) table records Joining tables Erasing records Altering columns Erasing columns Erasing tables What have I missed here? 7.MySQL Syntax (Working With Tables - Advanced) - Indices, transactions and sub-queries Advanced joins Sub-queries Indices Transactions Stored procedures Do you think I need a separate chapter for each of the above? What have I missed here? Section 3: Administration Section 4: Development -- -- Luke: I don't believe it! Yoda: That, is why you fail. --Star Wars: The Empire Strikes Back - 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
updated MySQL book
I guess this question is directed at Paul DuBois, I know he hangs out on this list: Is there, or are you planning on putting out, a shortened version of MySQL for people who are upgrading from your last book? i.e. I very much want to know the differences between the older and newer versions of the database, and I'd like to see what you've added to your new book, but I don't really need all the intro stuff all over again. Any thoughts? Thanks, -Lisi - 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: updated MySQL book
At 10:30 +0200 2/4/03, Lisi wrote: I guess this question is directed at Paul DuBois, I know he hangs out on this list: Is there, or are you planning on putting out, a shortened version of MySQL for people who are upgrading from your last book? Sorry, no. That wouldn't really work very well. The second edition isn't a first edition with some new pages stuck in here and there. True, there are a few sections that are completely new (such as the one on FULLTEXT searching). But in most cases new features are related to old ones, so the new material was woven into the existing material where it made most sense to include it, and old material was updated or corrected as necessary in parallel with the inclusion of the new stuff. i.e. I very much want to know the differences between the older and newer versions of the database, and I'd like to see what you've added to your new book, but I don't really need all the intro stuff all over again. The first edition came out about the time of MySQL 3.23.3. You can read the change notes section of the Reference Manual to see what's new since then. For a more succinct description of what's new in the book, there is a comparison page available at the companion web site: http://www.kitebird.com/mysql-book/ Any thoughts? Thanks, -Lisi - 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 Book by Dubois - Pg. 63 Tutorial Question
You are correct. It was a typo on my part. I forgot to copy the AND in the AND event.event_id = score.event_id; The problem is the same and I still receive an empty set message. You are also correct that there are events with the date of 1999-09-23. TIA for any assistance. D. H. Craig, CSM Paul DuBois [EMAIL PROTECTED] To: John Coder [EMAIL PROTECTED], [EMAIL PROTECTED] 06/25/2002 06:28 cc: [EMAIL PROTECTED] PM Subject: Re: MySQL Book by Dubois - Pg. 63 Tutorial Question At 19:40 -0400 6/25/02, John Coder wrote: [EMAIL PROTECTED] wrote: mysqlSELECT date, type, event_id FROM event; date type event_id 1999-09-03 Q 1 1999-09-03 Q 2 ... . Your date shows 199-09-03 mysql SELECT student_id, date, score, type -FROM event, score -WHERE date = 1999-09-23 -event.event_id = score.event_id; Empty set 0.00 sec mysql You qre asking for dates = 1999-09-23 Hence nothing matches Good try, but ... Bzzzt! :-) He only showed part of the table; there actually are records that match 1999-09-23. The real cause is more likely that there is a missing AND in the WHERE clause, which should read: WHERE date = 1999-09-23 AND event.event_id = score.event_id Why doesn't the query show any records? What am I doing wrong. Why is all I get an empty set? Any help would be appreciated. TIA Dave Craig D. H. Craig, CSM - 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
MySQL Book
We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have support for nested subQs, SPs and FKs with an alpha in early 2002, which is now but 4.0 is still alpha! 1. When can we have a 4.1 supporting nested subqueries, SPs FKs? 2. What would be a good way for us to be in your devel/test loop? Peter Brawley Arthur Fuller - 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 Book
On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote: We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have I must say, I think this is rather short-sighted of your publisher. I obviously do not speak for the MySQL folks but I don't think you should write a book on product features which do not exist yet. That said, it is often a better idea to move business logic out of the database and into another layer instead. At my previous job, we had to do this with MS SQL Server 2000 because the built-in triggers and foreign keys and the like were simply too slow so we did it programatically instead. Of course, we still used tranactions to ensure things were either all committed or all rolled back. In my opinion, this is the right approach to take with MySQL. - 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 Book
I agree with Chris... Writing a book on features that do not exist yet is asking for trouble. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL Book On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote: We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have I must say, I think this is rather short-sighted of your publisher. I obviously do not speak for the MySQL folks but I don't think you should write a book on product features which do not exist yet. That said, it is often a better idea to move business logic out of the database and into another layer instead. At my previous job, we had to do this with MS SQL Server 2000 because the built-in triggers and foreign keys and the like were simply too slow so we did it programatically instead. Of course, we still used tranactions to ensure things were either all committed or all rolled back. In my opinion, this is the right approach to take with MySQL. - 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 Book
Hi! - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, April 05, 2002 8:51 PM Subject: MySQL Book We are writing a book about MySQL. There will be emphasis on using MySQL with perl/php, .net java. The publisher needs lots of emphasis on SPs and nested subqueries. We need to be able to write about implementing biz rules using table constraints, which means FKs. Your site says 4.1 is to have support for nested subQs, SPs and FKs with an alpha in early 2002, which is now but 4.0 is still alpha! 1. When can we have a 4.1 supporting nested subqueries, SPs FKs? InnoDB type tables support foreign keys already in MySQL-3.23. See http://www.innodb.com/ibman.html#InnoDB_foreign_keys and http://www.innodb.com/todo.html. The current source tree of 4.1 already does some SQL subqueries. An inofficial timetable for stored procedures is 1 year. 2. What would be a good way for us to be in your devel/test loop? Simply download new versions from www.mysql.com, and test the features mentioned in the changelog in the manuals at http://www.mysql.com/doc/N/e/News-4.0.x.html and http://www.innodb.com/ibman.html#InnoDB_history. Peter Brawley Arthur Fuller Best regards, Heikki Tuuri Innobase Oy - 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
Tech Reviewer for a MySQL Book
Howdy, I'm about to put together a book on MySQL (in Peachpit Press' Visual QuickStart Guide series) and am looking for a tech reviewer. The book itself will be a step by step beginner's text to the world's best open source database. Running about 300 pages it will not be as comprehensive or professionally-oriented as, for example, Paul DuBois' most excellent book, MySQL (just so you can get a sense of the scope of the project and the target audience). The tech reviewer's responsibility is to go over what I have written, correct any technical errors, and make suggestions of what else to discuss. It is a paid position (amount to be determined by you and the publisher) and the reviewer receives free copies of the published book along with an honorable mention, normally. The process will take approximately 4 months--your ability to review chapters quickly is important--and it's all done via email. If you might be interested in this position, please email me with a quick synopsis of your skills (MySQL naturally, Perl, Java, PHP, etc), what version of MySQL you are running, and what operating systems you have access to for testing purposes. Also let me know if you have any questions or concerns. Thanks to everyone for their consideration! Larry - 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 Book
At 04:38 PM 2/21/2002 , you wrote: At 22:15 + 2/21/02, DL Neil wrote: MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) Not really, but because he thinks you are Paul of Idaho! =dn I ain't ne'er been to Idaho even once! I guess Paul doesn't like potatoes. lol Brent - 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
MySQL Book
Any book you guys recommend for learning the specific strenght of MySQL, I'm have a Oracle background and would like to learn more on MySQL. Stephane 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: MySQL Book
MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. -Original Message- From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 1:08 PM To: Mysql (E-mail) Subject: MySQL Book Any book you guys recommend for learning the specific strenght of MySQL, I'm have a Oracle background and would like to learn more on MySQL. Stephane 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 - 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 Book
The bible is MySQL by PAul DuBois ISBN: 0735709211 homepage: http://www.kitebird.com/mysql-book/ Gurhan -Original Message- From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 2:08 PM To: Mysql (E-mail) Subject: MySQL Book Any book you guys recommend for learning the specific strenght of MySQL, I'm have a Oracle background and would like to learn more on MySQL. Stephane 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 - 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 Book
At 13:25 -0600 2/21/02, Rick Emery wrote: MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) -Original Message- From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 1:08 PM To: Mysql (E-mail) Subject: MySQL Book Any book you guys recommend for learning the specific strenght of MySQL, I'm have a Oracle background and would like to learn more on MySQL. Stephane 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: MySQL Book
oops... Do I get credit for capitalizing the B in DuBois? GRIN -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 3:57 PM To: Rick Emery; 'Danis Stéphane '; Mysql (E-mail) Subject: RE: MySQL Book At 13:25 -0600 2/21/02, Rick Emery wrote: MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) -Original Message- From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 1:08 PM To: Mysql (E-mail) Subject: MySQL Book Any book you guys recommend for learning the specific strenght of MySQL, I'm have a Oracle background and would like to learn more on MySQL. Stephane 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: MySQL Book
MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) Not really, but because he thinks you are Paul of Idaho! =dn - 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 Book
At 22:15 + 2/21/02, DL Neil wrote: MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) Not really, but because he thinks you are Paul of Idaho! =dn I ain't ne'er been to Idaho even once! Are there any baseball teams there? Maybe I should go visit... - 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: Jeremy's MySQL Book
On Thu, Jan 10, 2002 at 05:35:04PM +0100, [EMAIL PROTECTED] wrote: Jeremy, Reading through the TOC, it sounds like a book I'd definitely buy! Great! At 15:58 2002-01-10, you wrote: 2. How to cover common problems in a way that folks can find them without reading the whole book? Maybe this is just an indexing issue. An item that Monty brought up is MySQL's non-graceful way of handles running out of disk space. That'll come up somewhere, but where would someone expect to find it? Should there be a list of things that every MySQL DBA needs to know? Maybe a short list that says read chapter XX to learn more about this topic and read chapter YY to learn more about that topic? You mention treating my.cnf, MySQL's Configuration File in chapter 1. But a common problem is the role of my.ini on Windows and where MySQL on Windows finds what (I think my.cnf is completely ignored, but I'm not quite sure; and the location of my.ini is frequently wrong (installer bug). Some of that is maybe more beginners stuff, but I'm suggesting you do at least treat both files. It's covered in Chapter 1 now. Thanks for the input. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 513,719,517 queries (266/sec. avg) - 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: Jeremy's MySQL Book
Hello all, Please advise location of the toc. Kind reagrds Emmanuel -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 16:59 To: Rick Emery Cc: '[EMAIL PROTECTED]' Subject: Re: Jeremy's MySQL Book On Thu, Jan 10, 2002 at 08:32:03AM -0600, Rick Emery wrote: Jeremy, Late last year, you were creating the Table of Contents for a book about MySQL...how's it coming? I know that many on this list were anxious to get a sneak peak, and perhaps suggest additional topics, such as advantages and conditions for using INNODB and BDB tables versus MYISAM. And how to install, configure and use MySQL ODBC drivers. Perhaps even how to access MS Access databases through MySQL. Hi Rick, I'll more information about the book on the web site I'm setting up for it (advanced-mysql.com). The domain is being registered today, so it'll be up over the weekend. In the meantime, here's the last TOC outline I had put together. Comments are welcome, of course. ---snip--- Title: Advanced MySQL (tentative) Chapter 0: Introduction Goals of this book * explain how mysql works under the hood * understand why it is fast what can slow it down (at all levels) * discuss real-world problems and solutions * expose good practices for use in large or demanding environments * discuss MySQL's weaknesses and how to work around them What you need to know (and why) * basic sql * mysql installation and administration * a scripting language (such as perl or python) What you won't read about (and why) * programming languages * the mysql api * extending or embedding mysql * clustering * commercial load-balancing solutions (there's a book on that) Chapter Overview Chapter 1: Configuration Basics (see Questions below) my.cnf, MySQL's Configuration File MySQL's Startup Options SHOW VARIABLES and SHOW STATUS Chapter 2: MySQL's Table Types (or Handlers?) MySQL's Modular Architecture * core services - sql parser - functions - logging * table handlers - data access - functionality differences * design benefits Locking and Concurrency * table vs. page vs. block vs. row (granularity) * read vs. write (exclusivity) * multi-versioning Transactional vs Non-Transactional * acid features - atomicity - consistency - isolation - durability * tradeoffs - concurrency - performance * simulating transactions with table locks (maybe a sidebar?) * isolation levels The Table Handlers * MyISAM (compressed MyISAM, and MERGE too) * HEAP * BDB (Berkeley DB) * InnoDB * Gemini * (possibly include a table which summarizes the features of all?) Selecting the Right Table Type Chapter 3: Indexes What are Indexes? * unique / non-unique indexes * unique non-indexes (in 4.x according to monty) * primary keys * partial indexes * compound (multi-part) indexes * packed keys How MySQL Stores and Maintains Indexes * storage requirements * common prefixes and space compression * where indexes are stored (for each table type) * hash indexes on heap tables * the myisam key buffer and innodb/gemini buffer pools * performance impact: updates vs. reads - discuss delayed key writes for myisam When Does MySQL Use an Index? * the most specific index * exact matches * ranges * the 40% rule * left-most prefixes * finding unused indexes * order by and group by queries * distinct queries * queries using only indexed columns When MySQL Never Uses and Index * regular expressions * wildcard prefix matches Understanding and Maintaining Your Indexes * Index File Sizes * SHOW KEYS * Cardinality * ANALYZE TABLE * Index Performance Counters * Index Buffers Full-text Indexing Chapter 4: Making Queries Fast How MySQL Processes Queries * query cache (new in 4.0 tree) * parsing * optimization planning * execution Identifying Slow Queries * the slow query log * using mysqldumpslow * using explain_log (new in 4.0) Using and Understanding EXPLAIN * single table select with index * single table select with no index * multi-way joins Influencing MySQL's Choices * straight joins * index hints in queries * analyze
Jeremy's MySQL Book
Jeremy, Late last year, you were creating the Table of Contents for a book about MySQL...how's it coming? I know that many on this list were anxious to get a sneak peak, and perhaps suggest additional topics, such as advantages and conditions for using INNODB and BDB tables versus MYISAM. And how to install, configure and use MySQL ODBC drivers. Perhaps even how to access MS Access databases through MySQL. rick - 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: Jeremy's MySQL Book
On Thu, Jan 10, 2002 at 08:32:03AM -0600, Rick Emery wrote: Jeremy, Late last year, you were creating the Table of Contents for a book about MySQL...how's it coming? I know that many on this list were anxious to get a sneak peak, and perhaps suggest additional topics, such as advantages and conditions for using INNODB and BDB tables versus MYISAM. And how to install, configure and use MySQL ODBC drivers. Perhaps even how to access MS Access databases through MySQL. Hi Rick, I'll more information about the book on the web site I'm setting up for it (advanced-mysql.com). The domain is being registered today, so it'll be up over the weekend. In the meantime, here's the last TOC outline I had put together. Comments are welcome, of course. ---snip--- Title: Advanced MySQL (tentative) Chapter 0: Introduction Goals of this book * explain how mysql works under the hood * understand why it is fast what can slow it down (at all levels) * discuss real-world problems and solutions * expose good practices for use in large or demanding environments * discuss MySQL's weaknesses and how to work around them What you need to know (and why) * basic sql * mysql installation and administration * a scripting language (such as perl or python) What you won't read about (and why) * programming languages * the mysql api * extending or embedding mysql * clustering * commercial load-balancing solutions (there's a book on that) Chapter Overview Chapter 1: Configuration Basics (see Questions below) my.cnf, MySQL's Configuration File MySQL's Startup Options SHOW VARIABLES and SHOW STATUS Chapter 2: MySQL's Table Types (or Handlers?) MySQL's Modular Architecture * core services - sql parser - functions - logging * table handlers - data access - functionality differences * design benefits Locking and Concurrency * table vs. page vs. block vs. row (granularity) * read vs. write (exclusivity) * multi-versioning Transactional vs Non-Transactional * acid features - atomicity - consistency - isolation - durability * tradeoffs - concurrency - performance * simulating transactions with table locks (maybe a sidebar?) * isolation levels The Table Handlers * MyISAM (compressed MyISAM, and MERGE too) * HEAP * BDB (Berkeley DB) * InnoDB * Gemini * (possibly include a table which summarizes the features of all?) Selecting the Right Table Type Chapter 3: Indexes What are Indexes? * unique / non-unique indexes * unique non-indexes (in 4.x according to monty) * primary keys * partial indexes * compound (multi-part) indexes * packed keys How MySQL Stores and Maintains Indexes * storage requirements * common prefixes and space compression * where indexes are stored (for each table type) * hash indexes on heap tables * the myisam key buffer and innodb/gemini buffer pools * performance impact: updates vs. reads - discuss delayed key writes for myisam When Does MySQL Use an Index? * the most specific index * exact matches * ranges * the 40% rule * left-most prefixes * finding unused indexes * order by and group by queries * distinct queries * queries using only indexed columns When MySQL Never Uses and Index * regular expressions * wildcard prefix matches Understanding and Maintaining Your Indexes * Index File Sizes * SHOW KEYS * Cardinality * ANALYZE TABLE * Index Performance Counters * Index Buffers Full-text Indexing Chapter 4: Making Queries Fast How MySQL Processes Queries * query cache (new in 4.0 tree) * parsing * optimization planning * execution Identifying Slow Queries * the slow query log * using mysqldumpslow * using explain_log (new in 4.0) Using and Understanding EXPLAIN * single table select with index * single table select with no index * multi-way joins Influencing MySQL's Choices * straight joins * index hints in queries * analyze tables for better statistics * query hints - SQL_BIG_RESULT - SQL_SMALL_RESULT - SQL_BUFFER_RESULT * avoiding the query cache (from monty) Built-in Optimizations * the 40% rule * index only selects * table-specific - innodb primary keys - gemini indexes * others (must
Re: Jeremy's MySQL Book
Jeremy, Reading through the TOC, it sounds like a book I'd definitely buy! At 15:58 2002-01-10, you wrote: 2. How to cover common problems in a way that folks can find them without reading the whole book? Maybe this is just an indexing issue. An item that Monty brought up is MySQL's non-graceful way of handles running out of disk space. That'll come up somewhere, but where would someone expect to find it? Should there be a list of things that every MySQL DBA needs to know? Maybe a short list that says read chapter XX to learn more about this topic and read chapter YY to learn more about that topic? You mention treating my.cnf, MySQL's Configuration File in chapter 1. But a common problem is the role of my.ini on Windows and where MySQL on Windows finds what (I think my.cnf is completely ignored, but I'm not quite sure; and the location of my.ini is frequently wrong (installer bug). Some of that is maybe more beginners stuff, but I'm suggesting you do at least treat both files. -- Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.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 Book
I prefer 'MySQL' by Michael Kofler (Apres ISBN 1893115577) D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. - 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 -- Dr. Frank Ullrich, Netzwerkadministration Verlag Heinz Heise GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 - 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
MySQL Book
Which is the **best, easy, compact** book available on MySQL. Delhi India. - 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 Book
MySQL by Paul DuBois www.newriders.com ISBN 0-7357-0921-1 This book is easy to use. It gets it right when it commes to newuser V olduser. Its not that compact but it is to the pont. Simon PS you also helps on the list some times.. -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 13:04 To: [EMAIL PROTECTED] Subject: MySQL Book Which is the **best, easy, compact** book available on MySQL. Delhi India. - 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 Book
MySql mSQL O'Reilly press isbn 1-56592-434-7 -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 1:04 PM To: [EMAIL PROTECTED] Subject: MySQL Book Which is the **best, easy, compact** book available on MySQL. Delhi India. - 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 Book
MySql mSQL O'Reilly press isbn 1-56592-434-7 is probably the worst book about mysql. Please note that the O'Reilly book was originally suppose to be about msql but near the end of the project they noticed that mysql was gaining popularity on msql so they threw in some information on mysql. Unfortunately it was too little, too late and didn't go through a proper review cycle. The second edition of the O'Reilly book is exclusively mysql and O'Reilly has acknowledged the problems with the first book. The 2nd edition should be out sometime soon with a new title. The best reference book on MySQL is still MySQL by Paul Dubois. - 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 Book
D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. I found that MySQL by Michael Kofler (Apress, ISBN 1-893115-57-7) was a rather good and informative book. Cheers, Markus -- Markus Lervik UNIX-administrator with a kungfoo grip Vaasa City Library - Regional Library - 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 Book
D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1 -- Regards, Doug - 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 Book
Ok. So majority is towards Paul DuBois. I went to the http://www.newriders.com/ to see about this book and found that this book was published in Dec 1999. Is new edition out. Is it good enough for new version of MySQL 3.23.39 / MySQL 4.0.x. I do not want to buy a book that is outdated or going to be outdated. Please comment. - Original Message - From: Doug Poland [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: D Bamud [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:26 AM Subject: Re: MySQL Book D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1 -- Regards, Doug - 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 Book
suitable for 3.22.x 3.23.x, but not enough good for 4.x -- Zu Zhihui [EMAIL PROTECTED] - Original Message - From: D Bamud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 1:51 PM Subject: Re: MySQL Book Ok. So majority is towards Paul DuBois. I went to the http://www.newriders.com/ to see about this book and found that this book was published in Dec 1999. Is new edition out. Is it good enough for new version of MySQL 3.23.39 / MySQL 4.0.x. I do not want to buy a book that is outdated or going to be outdated. Please comment. - Original Message - From: Doug Poland [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: D Bamud [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:26 AM Subject: Re: MySQL Book D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1 -- Regards, Doug - 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 Book
--- D Bamud [EMAIL PROTECTED] wrote: version of MySQL 3.23.39 / MySQL 4.0.x. I do not want to buy a book that is outdated or going to be outdated. Please comment. Yes, but good books are good books. This is a good book. I use SuSE 7.3, but get a lot of information from 2 books I favor written for SuSE 6.3. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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
Mysql Book
Are there anyone from Auckland , New Zealand that can tell me where I can get a good book on mysql? Thanks - 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: intro mysql book
another oracle dba [EMAIL PROTECTED] wrote: Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL Like you I too have come from an Oracle background to Mysql. Two main sources of information as far as I'm concerned: 1. The MySQL manual that comes with the source install, (also available on the site). I've got the HTML version readily accessible on the servers that are running MySQL. If it was multiple page HTML rather than a single file it'd be great. 2. MySQL by Paul DuBois. Like I've said on AmazonUK, I regard this as being the 'Kernighan and Ritchie' of MySQL. It's well written, reasonable concise, easy to follow and pretty good value-for-money. I could do without the chapters on installation and the API's myself, (I prefer to use the online manual as books tend to date in these areas fast), but I can see a use for them, (maybe less of the installation please in the revision for MySQL4.0 please Mr Dubois?). As an aside I also found 'PHP and MySQL' and 'SQL in a nutshell' (O'Reilly) quite useful. The Nutshell book is quite nice if you are an experienced code warrior with one of the other implementations of SQL. Just my random meanderings Bob Cross Disclaimer 1: writing for myself * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - 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
intro mysql book
Subject: intro mysql book Date: Fri, 14 Sep 2001 14:18:29 -0700 (PDT) From: another oracle dba [EMAIL PROTECTED] To: [EMAIL PROTECTED] Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL ** Your instincts are good. I found the Paul Dubois' book an excellent choice. I am at the same point you are at learning Mysql AND Transitioning from other SQL enviorments. I have , for many years used DB2 and Sybase. The books that have helped me are: MySQL By P Dubois.. ( Best Single MySQL Refrence) Teach Yourself MySQL in 21 Days ...SAMS..by Maslakowski.. (Takes you from Ignorant to Working Project). SQL In A Nutshell ..O'Reilly by Kline Kline.. Most SQL commands w/ examples in MySQL, Oracle PostgreSQL, SQL Server.. For each command Great for Transition! Mysql/PHP Database Applications MT Books by Greenspan and Bulger ..You will understand the Marriage. Good luck Bob T - 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: intro mysql book
Other than the manual, Sam's Teach Yourself MySQL in 21 Days is a great book. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: rjtalbo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 15, 2001 3:24 PM Subject: intro mysql book Subject: intro mysql book Date: Fri, 14 Sep 2001 14:18:29 -0700 (PDT) From: another oracle dba [EMAIL PROTECTED] To: [EMAIL PROTECTED] Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL ** Your instincts are good. I found the Paul Dubois' book an excellent choice. I am at the same point you are at learning Mysql AND Transitioning from other SQL enviorments. I have , for many years used DB2 and Sybase. The books that have helped me are: MySQL By P Dubois.. ( Best Single MySQL Refrence) Teach Yourself MySQL in 21 Days ...SAMS..by Maslakowski.. (Takes you from Ignorant to Working Project). SQL In A Nutshell ..O'Reilly by Kline Kline.. Most SQL commands w/ examples in MySQL, Oracle PostgreSQL, SQL Server.. For each command Great for Transition! Mysql/PHP Database Applications MT Books by Greenspan and Bulger ..You will understand the Marriage. Good luck Bob T - 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: intro mysql book
Hello All! Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL Yes, as others have said, the Paul Dubois book is -excellent.- Teach Yourself MySQL in 21 Days ...SAMS..by Maslakowski.. (Takes you from Ignorant to Working Project). Avoid it like the PLAGUE. A 'printed disaster'. I've been reading tech books for 25 years and have *never* before seen such a poor piece of work. Have I made my point? :) No? Read on! The sample perl is -wrong-. The scripts flat out -fail- -wc compilation. As printed it simply literally does not work. The CD does not match the book, and -both- are -wrong-. The sample HTML *was* literally copy/pasted from FrontPage (meta name=GENERATOR content=Microsoft FrontPage 4.0). Totally -filled- with font and width foolishness that takes twice as much printed space as necessary and that I had to -squint- through to figure out what was supposed to be going on. Other comments I sent to the author: (The HTML on the CD was, as gently as I can put it, fairly hysterical. :) The idea of a few lines of INPUT... TEXT... with no FORM /FORM tags just broke me up. :) But that was less important to me because I know enough about HTML to easily figure it out, and the book was far more correct in those aspects.) The more serious problems for the SQL-newbie start with Listing 21-2 on page 406, AddCustomer.pl. There is a 'my $dbh' line, and several 'do' lines. But a few lines down there are several '$dbi-do' lines. There is no 'my $dbh', and I don't know exactly what kind of line to add for that. Bear in mind that I'm reading that as a raw virgin newbie. I spent -hours- trying to figure out what I was doing wrong. At this point I -KNOW- I am reading untested software. Some errors I figured out, but the most -important- aspects of this script, the GRANTs, is totally uncommented, and I can't get it to run at all, just lots of lines of errors in the server logs that I won't bother including here. There is a line that says '# Create the user in the MySQL database', but there is no reference to -opening- the mysql.user database, that I 'think' should be there. I think that's where the my-dbi should be. Then there's the 'print Location:' line that references 'CustomerAdd.html' that as far as I cn see does not exist, and I can't quite guess what it's supposed to mean. That \nURI at the end of the line sure looks weird, not the way I've ever used Location. And this appears to be not the correct use of Location. The 'print Location' should be the -last- thing sent to the user, after which the script should end. The client will -not- receive anything sent after that. Yes, the line says literally (wrapped): print Location: http://CustomerAdd.html\nURI: http://CustomerAdd.html\n\n; ; There's a line on page 396, 'Quantity INT, NOT NULL,' clearly an error showing that this is untested. I seem to recall other minor errors but can't find any at a quick glance. No errata has ever been posted to samspublishing.com even though I was told a year ago that it'd ready 'in a few days.'. I will obviously never buy another Sams book either. Check the author's info at http://www.samspublishing.com/authors_sams.cfm. Not there? Oh. Biggest waste of $40 and hours or reading I ever spent in my life. Nuff said? To be fair, I did learn how to create a database, import some data, log in to the server, and do a few simple queries. But that's it. Have a :) day! jb -- jim barchuk [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
intro mysql book
Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL internals from the dba standpoint as well as usage from a developer standpoint. I'm going to take a look at MySQL by Paul Dubois. It seems to have good reviews, but would be interested in other recommendations. thanks __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ - 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