If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.
Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.
Create and alter MySQL tables and specify fields and columns within them
Learn how to insert, select, update, delete, join, and subquery data, using practical examples
Use built-in string functions to find, extract, format, and convert text from columns
Learn functions for mathematical or statistical calculations, and for formatting date and time values
Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data
Use APIs to connect and query MySQL and MariaDB with PHP and other languages
Russell Dyer is a freelance writer specializing in MySQL database software and is the editor of the MySQL Knowledge Base (http://www.mysql.com/network/knowledgebase.html). He is the author of MySQL in a Nutshell (http://www.oreilly.com/catalog/mysqlian/) and has writen articles for several magazines: Dev Zone (a MySQL publication), Linux Journal, ONlamp.com, The Perl Journal, Red Hat Magazine, SysAdmin Magazine, Tech Republic, Unix Review, and XML.com. He has also finished his first novel, "In Search of Kafka". More information on Russell, along with a list of his published articles with links to them, can be found on his web site at http://russell.dyerhouse.com
The animals on the cover of Learning MySQL and MariaDB are bandedangelfish (Apolemichthys arcuatus), so named for the blackband that runs on either side of each fish's body from the eye to its tail. The bandedangelfish's laterally svelte body and soft dorsal fin are typical of the other marine angelfishin its Pomacanthidae family. Known also as bandit angelfish, members of this species inhabit thecaves and ledges of rocky reefs found at moderate depths in the waters around Hawaii and theJohnson Atoll.
The behavior of marine angelfish differs widely between species, and members of the Pomacanthidae family are as likely to form monogamous pairs as gather in groups of one male marine angelfish to several females. As protogynous hermaphrodites, marine angelfish are capable of changing sex from female to male when the single male member of such a group dies or is otherwise removed.
Sponges constitute the bulk of the banded angelfish's diet, though it also eats algae andcertain invertebrates. Difficulty replicating the banded angelfish's diet is a major impedimentto the efforts of collectors who would keep banded angelfish in aquaria. Nevertheless,commercial aquarium fishermen appear to have thinned the population at normal diving depths oncertain reefs.
Many of the animals on O'Reilly covers are endangered; all of them are important to the world. To learn more about how you can help, go to animals.oreilly.com.
The cover image is from Cuvier's Animals. The cover fonts are URW Typewriterand Guardian Sans. The text font is Adobe Minion Pro; the heading font is AdobeMyriad Condensed; and the code font is Dalton Maag's Ubuntu Mono.