To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly. Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains: * How to configure MySQL, such as setting the root password * MySQL data types, including numerics, strings, dates, and complex types * SQL syntax, commands, data types, operators, and functions * Arithmetic, comparison and logical operators * Aggregate and general functions * Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.

George Reese is the founder of two Minneapolis-based companies, enStratus Networks LLC (maker of high-end cloud infrastructure management tools) and Valtira LLC (maker of the Valtira Online Marketing Platform). Over the past 15 years, George has authored a number of technology books, including MySQL Pocket Reference, Database Programming with JDBC and Java, Java Database Best Practices, and the upcoming Web Architecture and Programming in the Cloud.

Inhaltsverzeichnis      Introduction      MySQL 5             Views             Triggers             Stored Procedures             Cursors             New Storage Engines             Database Events      Setup             Downloading MySQL             Configuration             Startup             Set the Root Password             Replication      Command-Line Tools      Data Types             Numerics             Strings             Dates             Complex Types      SQL             Case Sensitivity             Literals             Identifiers             Comments             Commands             Transaction Rules      Operators             Rules of Precedence             Arithmetic Operators             Comparison Operators             Logical Operators      Functions             Aggregate Functions             General Functions      Storage Engines      Stored Procedures and Functions             Parameters             Logic             Handlers and Conditions      Triggers Index

Hersteller:
dpunkt.verlag GmbH
Vanessa Niethammer
hallo@dpunkt.de
Wieblinger Weg 17
DE 69123 Heidelberg