MySQL Pocket Reference (Pocket Reference (O'Reilly))

by George Reese (Author)

• Used

  Mass Market Paperback
  2003

  $3.42

  If you use MySQL, you know why it's the world's most popular open source database: small, fast, and powerful, and so rich in features that no administrator or programmer can stay familiar with all of them. There are always some little-known commands and clauses that could help you become more efficient in your work if you could just keep them in mind. The problem is, you don't always have time to stop and thumb through an exhaustive reference when you're hard at work. If you need a quick reminder, the MySQL Pocket Reference can lead you straight to the answer you need to know to get the job done. Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. A complete reference to the MySQL version of SQL, it also serves as a convenient companion to our large, in-depth volume, Managing and Using MySQL and covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions.

• New

  Paperback
  2007

  $15.92

  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. MySQL 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. 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.