May 2005
Intermediate to advanced
352 pages
14h 39m
English
Content preview from MySQL in a NutshellBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
How This Book Is Organized
This book is broken up into fourteen chapters and three appendixes, as follows:
Chapter 1, explains the major components of MySQL and useful guidelines for getting information and dealing with the MySQL community.
Chapter 2, describes how to get MySQL running on all the systems supported by MySQL AB. It is necessary to read this chapter only if your system does not already have MySQL installed.
Chapter 3, introduces SQL and use of the mysql command-line utility. It is no replacement for learning SQL and relational database design, but can be useful to orient you.
Chapter 4, is the major chapter in this book, a comprehensive listing of all SQL statements supported by MySQL and their subclauses.
Chapter 5, covers SQL functions for manipulating text data.
Chapter 6, covers SQL functions that manipulate the various data and time formats supported by MySQL.
Chapter 7, covers mathematical SQL functions and
functions used for combining information in columns, such as
MAX( ) and COUNT( ).
Chapter 8, covers SQL functions, such as
CASE and IF.
Chapter 9, covers SQL functions that can be used to control or get information about the database engine, and do other miscellaneous tasks.
Chapter 10, covers the options for the mysqld daemon, the mysql command-line client, and related commands.
Chapter 11, covers other commands for administering MySQL and its data.
Chapter 12 presents the Perl DBI module, used to access MySQL databases from Perl.
Chapter 13, presents the PHP functions ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.