George Reese

MySQL Pocket Reference (eBook, ePUB)

SQL Functions and Utilities

• Format: ePub

Produktbeschreibung

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 passwordMySQL data types, including numerics, strings, dates, and complex typesSQL syntax, commands, data types, operators, and functionsArithmetic, comparison and logical operatorsAggregate and general functionsStored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggersYou 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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 134
• Erscheinungstermin: 17. Juli 2007
• Englisch
• ISBN-13: 9780596551698
• Artikelnr.: 52825782

Autorenporträt

George Reese is the founder and President of Valtira LLC inMinneapolis, MN and author of technology books such as the MySQL Pocket Reference, Database Programming with JDBC and Java, and Java Database Best Practices. Throughout the Internet era, he has spent his career applying enterprise and web technologies to the marketing domain. He is the creator of the Simplicis Marketing Dashboard, the core product from Valtira.George holds a BA in Philosophy from Bates College in Lewiston, Maine and an MBA from the Kellogg School of Management in Evanston, Illinois. He currently lives in Minnesota with his wife and two daughters.

Inhaltsangabe

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