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