MySQL Cookbook
Solutions for Database Developers and Administrators
Seiten
2022
|
4th New edition
O'Reilly Media (Verlag)
978-1-4920-9316-9 (ISBN)
O'Reilly Media (Verlag)
978-1-4920-9316-9 (ISBN)
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. This updated fourth edition provides more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0.
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.
You'll learn how to:
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
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.
You'll learn how to:
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
Sveta Smirnova is a MySQL Support Engineer at Percona. Her main professional interests are problem-solving, working with tricky issues and bugs, and teaching others how to deal with MySQL issues, bugs and gotchas effectively. In addition to authoring "MySQL Troubleshooting" and "JSON UDF Functions for MySQL", Sveta has spoken at many events, including Fosdem, Percona Live, and Oracle Open World. Alkin Tezuysal is a Senior Technical Manager at Percona. He has extensive experience in enterprise relational databases, working in various sectors for large corporations. With more than 20 years of industry experience, Alkin has acquired skills for managing large projects from the ground up to production.
Erscheinungsdatum | 16.08.2022 |
---|---|
Verlagsort | Sebastopol |
Sprache | englisch |
Maße | 178 x 232 mm |
Themenwelt | Mathematik / Informatik ► Informatik ► Software Entwicklung |
ISBN-10 | 1-4920-9316-5 / 1492093165 |
ISBN-13 | 978-1-4920-9316-9 / 9781492093169 |
Zustand | Neuware |
Informationen gemäß Produktsicherheitsverordnung (GPSR) | |
Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
Entwurfsmuster für effektive Softwareentwicklung
Buch | Softcover (2024)
Springer Vieweg (Verlag)
19,99 €
Deterministische und randomisierte Algorithmen
Buch | Softcover (2024)
De Gruyter Oldenbourg (Verlag)
64,95 €
Grundlagen, Prozesse, Methoden und Werkzeuge
Buch | Hardcover (2024)
Springer Vieweg (Verlag)
99,99 €