Managing & Using MySQL

Managing & Using MySQL
Author: George Reese
Publisher: "O'Reilly Media, Inc."
Total Pages: 445
Release: 2002
Genre: Computers
ISBN: 0596002114

MySQL is a robust open source database product that supports key subsets of SQL on both Linux and Unix systems. This text goes through the whole process from installation and configuration to programming interfaces and database administration.

Mysql Management and Administration With Navicat

Mysql Management and Administration With Navicat
Author: Gökhan Ozar
Publisher: Packt Pub Limited
Total Pages: 134
Release: 2012
Genre: Computers
ISBN: 9781849687461

Standard Mini. This book is written for MySQL Users, Developers, and admins who want to discover just how easy Navicat makes even normally arduous tasks.

MySQL Reference Manual

MySQL Reference Manual
Author: Michael Widenius
Publisher: "O'Reilly Media, Inc."
Total Pages: 822
Release: 2002
Genre: Computers
ISBN: 9780596002657

This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.

Database Design Manual: using MySQL for Windows

Database Design Manual: using MySQL for Windows
Author: Matthew Norman
Publisher: Springer Science & Business Media
Total Pages: 213
Release: 2003-10-09
Genre: Computers
ISBN: 1852337168

Essential SQL fast provides a comprehensive guide to SQL, using the Windows-based version of MySQL. MySQL is a freely available, multi-platform database management system, making it ideal for learning the techniques and concepts of database design. Using numerous worked examples and illustrations, Matthew Norman describes how to set up the database management system MySQL. In doing so he covers various topics, including: installing and testing MySQL; using the graphical tools; database design techniques and concepts; retrieving, changing and deleting data; and how to make other products communicate with MySQL.

MySQL and MSQL

MySQL and MSQL
Author: Randy Jay Yarger
Publisher: O'Reilly Media
Total Pages: 522
Release: 1999
Genre: Computers
ISBN:

A guide to the SQL-based database applications covers installation, configuration, interfaces, and administration.

MySQL Crash Course

MySQL Crash Course
Author: Ben Forta
Publisher: Addison-Wesley Professional
Total Pages: 635
Release: 2023-11-02
Genre: Computers
ISBN: 0138223165

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. This book will teach you all you need to know to be immediately productive with the latest version of MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn How To Retrieve and Sort Data Filter Data Using Comparisons, Regular Expressions, Full Text Search, and Much More Join Relational Data Create and Alter Tables Insert, Update, and Delete Data Leverage the Power of Stored Procedures and Triggers Use Views and Cursors Manage Transactional Processing Create User Accounts and Manage Security via Access Control

MySQL Cookbook

MySQL Cookbook
Author: Paul DuBois
Publisher: "O'Reilly Media, Inc."
Total Pages: 1101
Release: 2014-07-28
Genre: Computers
ISBN: 144937414X

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. 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 solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration

SQL for MySQL Developers

SQL for MySQL Developers
Author: Rick F. van der Lans
Publisher: Pearson Education
Total Pages: 1117
Release: 2007-04-20
Genre: Computers
ISBN: 0132715899

The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer, Web developer, analyst, DBA, or database user, this book can take you from “apprentice” to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.

Learning MySQL

Learning MySQL
Author: Seyed Tahaghoghi
Publisher: "O'Reilly Media, Inc."
Total Pages: 620
Release: 2007-11-28
Genre: Computers
ISBN: 0596008643

This new book in the popular Learning series offers an easy-to-use resource for newcomers to the MySQL relational database. This tutorial explains in plain English how to set up MySQL and related software from the beginning, and how to do common tasks.

High Performance MySQL

High Performance MySQL
Author: Silvia Botros
Publisher: "O'Reilly Media, Inc."
Total Pages: 389
Release: 2021-10-18
Genre: Computers
ISBN: 1492080489

How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide also teaches database administrators safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in cloud- and self-hosted MySQL, InnoDB performance, and new features and tools, this revised edition helps you design a relational data platform that will scale with your business. You'll learn best practices for database security along with hard-earned lessons in both performance and database stability. Dive into MySQL's architecture, including key facts about its storage engines Learn how server configuration works with your hardware and deployment choices Make query performance part of your software delivery process Examine enhancements to MySQL's replication and high availability Compare different MySQL offerings in managed cloud environments Explore MySQL's full stack optimization from application-side configuration to server tuning Turn traditional database management tasks into automated processes