MySQL. Cookbook

Ready-made recipes for solving practical tasks when working with the MySQL database management system are considered. Basic principles of connecting to the MySQL server, retrieving data from the server, executing and processing queries are described. Ways to save, extract, and modify rows, work with dates and times are discussed, with examples of sorting query results and creating summaries. Methods for evaluating the characteristics of a dataset, creating stored functions and procedures are considered. Practical examples of using stored subprograms, triggers, and scheduled events are provided. Special attention is paid to the basics of monitoring and administration techniques for MySQL