MySQL Cookbook by Paul DuBois
While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut.MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or recipe--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations.The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to: Import data from external sources Export data for use by external programs Access MySQL from your web server Use scripts with MySQL to read queries from a file Access MySQL from within client programs that use Perl, PHP, Java, Python and other languages Construct queries that solve commonly-occurring questions Interact with the serverThis learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch. Editorial Reviews Amazon.com Review Good programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel. If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process. DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You'll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they're working with, or that they're able to transliterate the one DuBois has provided. It's usually not a big problem. --David Wall Topics covered: How to make MySQL databases do your bidding--in terms of queries, table manipulation, data formatting, transactions, and Web interfaces--through the database server's command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques. About the Author is one of the primary contributors to the MySQL Reference Manual, a renowned online manual that has supported MySQL administrators and database developers for years, now available in an attractive paper format from the O'Reilly Community Press. He is also the author of Using csh & tcsh and Software Portability with imake by O'Reilly, as well as MySQL and MySQL and Perl for the Web by New Riders.
Publication Details
Title:
Author(s):
Illustrator:
Binding: Paperback
Published by: O'Reilly Media: , 2002
Edition:
ISBN: 9780596001452 | 0596001452
1022 pages.
Book Condition: Very Good
Pickup currently unavailable at Book Express Warehouse
Product information
New Zealand Delivery
Shipping Options
Shipping options are shown at checkout and will vary depending on the delivery address and weight of the books.
We endeavour to ship the following day after your order is made and to have pick up orders available the same day. We ship Monday-Friday. Any orders made on a Friday afternoon will be sent the following Monday. We are unable to deliver on Saturday and Sunday.
Pick Up is Available in NZ:
Warehouse Pick Up Hours
- Monday - Friday: 9am-5pm
- 35 Nathan Terrace, Shannon NZ
Please make sure we have confirmed your order is ready for pickup and bring your confirmation email with you.
Rates
-
New Zealand Standard Shipping - $6.00
- New Zealand Standard Rural Shipping - $10.00
- Free Nationwide Standard Shipping on all Orders $75+
Please allow up to 5 working days for your order to arrive within New Zealand before contacting us about a late delivery. We use NZ Post and the tracking details will be emailed to you as soon as they become available. Due to Covid-19 there have been some courier delays that are out of our control.
International Delivery
We currently ship to Australia and a range of international locations including: Belgium, Canada, China, Switzerland, Czechia, Germany, Denmark, Spain, Finland, France, United Kingdom, United States, Hong Kong SAR, Thailand, Philippines, Ireland, Israel, Italy, Japan, South Korea, Malaysia, Netherlands, Norway, Poland, Portugal, Sweden & Singapore. If your country is not listed, we may not be able to ship to you, or may only offer a quoting shipping option, please contact us if you are unsure.
International orders normally arrive within 2-4 weeks of shipping. Please note that these orders need to pass through the customs office in your country before it will be released for final delivery, which can occasionally cause additional delays. Once an order leaves our warehouse, carrier shipping delays may occur due to factors outside our control. We, unfortunately, can’t control how quickly an order arrives once it has left our warehouse. Contacting the carrier is the best way to get more insight into your package’s location and estimated delivery date.
- Global Standard 1 Book Rate: $37 + $10 for every extra book up to 20kg
- Australia Standard 1 Book Rate: $14 + $4 for every extra book
Any parcels with a combined weight of over 20kg will not process automatically on the website and you will need to contact us for a quote.
Payment Options
On checkout you can either opt to pay by credit card (Visa, Mastercard or American Express), Google Pay, Apple Pay, Shop Pay & Union Pay. Paypal, Afterpay and Bank Deposit.
Transactions are processed immediately and in most cases your order will be shipped the next working day. We do not deliver weekends sorry.
If you do need to contact us about an order please do so here.
You can also check your order by logging in.
Contact Details
- Trade Name: Book Express Ltd
- Phone Number: (+64) 22 852 6879
- Email: sales@bookexpress.co.nz
- Address: 35 Nathan Terrace, Shannon, 4821, New Zealand.
- GST Number: 103320957 - We are registered for GST in New Zealand
- NZBN: 9429031911290
We have a 30-day return policy, which means you have 30 days after receiving your item to request a return.
To be eligible for a return, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase.
To start a return, you can contact us at sales@bookexpress.co.nz. Please note that returns will need to be sent to the following address: 62 Kaiwharawhara Road, Wellington, NZ once we have confirmed your return.
If your return is accepted, we’ll send you a return shipping label, as well as instructions on how and where to send your package. Items sent back to us without first requesting a return will not be accepted.
You can always contact us for any return question at sales@bookexpress.co.nz.
Damages and issues
Please inspect your order upon reception and contact us immediately if the item is defective, damaged or if you receive the wrong item, so that we can evaluate the issue and make it right.
Exceptions / non-returnable items
Certain types of items cannot be returned, like perishable goods (such as food, flowers, or plants), custom products (such as special orders or personalized items), and personal care goods (such as beauty products). We also do not accept returns for hazardous materials, flammable liquids, or gases. Please get in touch if you have questions or concerns about your specific item.
Unfortunately, we cannot accept returns on sale items or gift cards.
Exchanges
The fastest way to ensure you get what you want is to return the item you have, and once the return is accepted, make a separate purchase for the new item.
European Union 14 day cooling off period
Notwithstanding the above, if the merchandise is being shipped into the European Union, you have the right to cancel or return your order within 14 days, for any reason and without a justification. As above, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase.
Refunds
We will notify you once we’ve received and inspected your return, and let you know if the refund was approved or not. If approved, you’ll be automatically refunded on your original payment method within 10 business days. Please remember it can take some time for your bank or credit card company to process and post the refund too.
If more than 15 business days have passed since we’ve approved your return, please contact us at sales@bookexpress.co.nz.