MySQL Cookbook Solutions for Database Developers and Administrators, 4th Edition (Sveta Smirnova, Alkin Tezuysal) (Z-Library)

Author： Sveta Smirnova, Alkin Tezuysal

For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to resolve MySQL problems from scratch. In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON. Inside You’ll find: ✓ Connect to a server, issue queries, and retrieve results ✓ Retrieve data from the MySQL Server ✓ Store, retrieve, and manipulate strings ✓ Work with dates and times ✓ Sort query results and generate summaries ✓ Assess the characteristics of a dataset ✓ Write stored functions and procedures ✓ Use stored routines, triggers, and scheduled events ✓ Perform basic MySQL administration tasks ✓ Understand MySQL monitoring fundamentals

AI Reading Assistant

Whole-book reading guide from stratified index samples; jump to passages in the text

Generate book guide

Help cover token costs

Tip the Site

Support this site Your recognition and a small knowledge-service contribution help keep this technical work open source. Scan the WeChat Pay or Alipay code below. Logged-in and guest visitors can both tip.

Open WeChat or Alipay and scan. No login required.

Passage locations

Ask

Collapse guide