This guide contains a wealth of solutions to problems that SQl Server programmers face. The recipes in the book range from those that show how to perform simple tasks to ones that are more complicated.
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 Cookbookprovides 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. ButMySQL Cookbookis 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 server This learn-as-you-go resource will help users of all levels exploit MySQL more fully.MySQL Cookbooksupplies 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.
Rather than theory, this text provides easy-to-find coding solutions to real problems, offering clear explanations of how and why the code works, potential pitfalls, and sources of additional information.
Provides an overview of the features and functions of the program, discussing such topics as building queries, importing and exporting data, creating reports, securing a database, and distributing an Access application.