- Paperback: 612 pages
- Publisher: Mike Murach & Associates; 5/14/12 edition (May 1, 2012)
- Language: English
- ISBN-10: 1890774685
- ISBN-13: 978-1890774684
- Product Dimensions: 8 x 1.5 x 10.2 inches
- Shipping Weight: 3 pounds (View shipping rates and policies)
- Average Customer Review: 72 customer reviews
- Amazon Best Sellers Rank: #876,176 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Murach's MySQL Paperback – May 1, 2012
Customers who viewed this item also viewed
Customers who bought this item also bought
About the Author
Joel Murach has been writing and editing books about computer programming for over 10 years. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. When he's not programming or writing books about programming, he can be found surfing or writing music.
72 customer reviews
Review this product
Read reviews that mention
Showing 1-7 of 72 reviews
There was a problem filtering reviews right now. Please try again later.
When the author talks about DELETE statement. He states in Chapter 7: "MySQL returns an error message if you attempt to delete a row from the Vendors table that has related rows in the Invoices table. Usually that’s what we want."
I was scratching my head a couple times when he mentioned this. Then I remembered I had to 'CASCADE CONSTRAINTS' when deleting certain tables from Oracle SQL. Notice the author doesn't mention 'foreign key constraint' in that quoted sentence, which would have been 10 times more understandable, since one could just a do a google search on that term, instead of waiting until the book's 11th chapter where he goes into detail about foreign keys.
The book doesn't go into proper detail as to how to set up MySQL Workbench. Thanks to asking on internet forums, I found out I needed a secondary app, such as XAMPP, to get Workbench up and running.
The book did go a long way to get me ready in Oracle SQL, at an introductory, despite MySQL using slightly different syntax in some areas here and there. Also the book doesn't talk about how to create tables and primary/foreign key constraint until the 11th chapter. But doing these things is far easier than performing search queries; so I wouldn't call it a negative, but my introductory database class at a 4-year college did go into that first hand. The exercise questions at the end of each chapter are indeed helpful and do help one further their understanding of the SQL in general, although some questions are worded confusingly. The author provides the full query answer on his website.
At the 'used like new' price I bought this book for, I'd say its definitely worth it.
Downloaded msq2_allfiles from the murach website, in "db_setup" folder, there are 2 "create_database" files, one for "MySQL 5.7 and later". Neither works.
Tried both in MySQL workbench.
1. Since I just downloaded MySQL Community Server 8.0.11, I think I should go with "create_database-MySQL 5.7 and later", opened and executed, tried "SELECT * FROM terms;", got error message"Error code: 1146. Table 'om.terms' doesn't exist"
2. Then I opened and executed "create_database", got error message "Error code: 1064. You have an error in your SQL syntax". Strange thing is, I can successfully execute "SELECT * FROM terms;"
It's not very friendly to new users like me, I am feeling very frustrated.
The two page format puts the description of the topic on the left page with example code on the left combine that with a great index and you have a tool you can draw from when you need to figure out some of the esoteric functions that someone else has used or need to figure the proper join to use. The pages are organized into section if you want to do some quick reading about the whole topic. I have purchased other Murach's books that are published in the same format and I have yet to be disappointed.