MySQL is a multi-user database management system.
It is developed by MySQL AB, and installed at at least 10 million sites worldwide.
The software is
under the GPL
proprietary commercial license,
as well as being available on a subscription model.
Although MySQL can be used with a wide variety of programming tools, it is especially commonly
used in conjunction with PHP.
Here are some books about MySQL:
Disclosure: Products details and descriptions provided by Amazon.com. Our company may receive a payment if you purchase products from them after following a link from this website.
Product Description: MySQL, Fifth Edition by Paul DuBois The definitive guide to using, programming and administering MySQL 5.5 and MySQL 5.6
MySQL provides a comprehensive guide to effectively using and administering the MySQL database management system (DBMS).
Author Paul DuBois describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The book also includes a comprehensive reference section providing detailed information on MySQL’s structure, language, syntax, and APIs.
The fifth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.5, as well as to add new coverage of features introduced with MySQL 5.6.
MySQL is an open source relational database management system (DBMS) that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications. MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it.
Paul DuBois' MySQL, Fifth Edition, is the definitive guide to fully exploiting all the power and versatility of MySQL 5.5 and MySQL 5.6 Contents at a Glance
Part I: General MySQL Use Chapter 1 Getting Started with MySQL Chapter 2 Using SQL to Manage Data Chapter 3 Data Types Chapter 4 Views and Stored Programs Chapter 5 Query Optimization
Part II: Using MySQL Programming Interfaces Chapter 6 Introduction to MySQL Programming Chapter 7 Writing MySQL Programs Using C Chapter 8 Writing MySQL Programs Using Perl DBI Chapter 9 Writing MySQL Programs Using PHP
Part III: MySQL Administration Chapter 10 Introduction to MySQL Administration Chapter 11 The MySQL Data Directory Chapter 12 General MySQL Administration Chapter 13 Security and Access Control Chapter 14 Database Maintenance, Backups, and Replication
Part IV: Appendixes Appendix A Software Required to Use This Book Appendix B Data Type Reference Appendix C Operator and Function Reference Appendix D System, Status, and User Variable Reference Appendix E SQL Syntax Reference Appendix F MySQL Program Reference
Appendix G C API Reference
Appendix H Perl DBI API Reference Appendix I PHP API Reference
"If you ever wanted to learn to use MySQL, write SQL queries, create database elements, then this is the book to pick up." (JavaRanch.com)
"I was amazed at how much information was packed into this book."
"As a developer with almost 10 years of MySQL experience, I still picked up a lot of new detail on things I thought I knew."
"I found this to be a great introductory book to MySQL."
"Has already proven to be helpful in solving several challenges I've encountered on my current MySQL project."
That's a sampling of what developers said about the 1st Edition of Murach's MySQL.
Now, this 2nd Edition has been updated and improved throughout. As a result, it's easier than ever to use for learning MySQL from scratch, for switching to MySQL from another flavor of SQL (like MS SQL Server or Oracle), or for quickly looking up the forgotten details that are so essential as you develop database applications.
Section 1 introduces you to relational databases and SQL, shows you how to use the graphical MySQL Workbench to work with a MySQL database, and teaches you to code SQL queries to retrieve, add, update, and delete data in a MySQL database. Section 2 goes deeper into querying, showing you how to work with summary queries, subqueries, data types, and functions. Section 3 shows you how to design a MySQL database using an EER model, implement the design, and create views. Section 4 shows how to create stored procedures that provide functionality similar to procedural programming languages like PHP, Java, C++, C#, and VB. And Section 5 introduces you to database administration tasks like securing and backing up database data.
Whether you start from the beginning or jump in anywhere, it's a great guide for MySQL users at any level.
Master Application Development in a Mixed-Platform Environment
Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume.
Understand Oracle Database 11g and MySQL 5.6 architecture
Convert databases between platforms and ensure transactional integrity
Create tables, sequences, indexes, views, and user accounts
Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts
Execute complex queries and handle numeric and date mathematics
Merge data from source tables and set up virtual directories
Product Description: MySQL Explained is a step-by-step tutorial for everyone who's ready to learn about the database software most commonly used for storing information behind some of today's most popular websites and online applications. Written especially for people outside the technology field, MySQL Explained provides the background information you need to get familiar with database theory and the principles behind organizing data. This book starts from the ground up, helping the reader to understand the very definition of a database, the forms it can take and the different options for storing information. By the end of this book, you'll understand the reasons for choosing MySQL, the options for installing it and the tools that it offers to store and safeguard your data. If you are in any way involved in designing or managing a website or data solution of any kind, you owe it to yourself to understand the tools involved. Quality database management systems are essential in today's data-driven world and such essential tools should not be a mystery to those who depend on them. MySQL Explained can help you unravel the mystery and learn more about a technology that will be around for a long time to come. This edition provides improvements in formatting and readability over the 2015 edition.
Product Description: This book covers most likely asked MySQL interview questions with their good explanation and relevant answers. Experienced MySQL developers share their common interview questions and experience to let you prepare for the technical interview session. It is in demand for the IT market that developer must possess good database knowledge. Every project is incomplete without the database interaction. Websites, CRM, software all needs a particular database system to manage their set of information and correlated data. This book helps to to prepare MySQL interview with confidence.
Take a positive step to boost your carrier and get your copy today !
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
The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to:
Deploy the right MySQL product for your performance needs.
Set up a performance management and monitoring environment using tools from MySQL.
Implement the right indexing strategy
Apply good performance strategy when developing software to work with the MySQL database.
Configure dozens of variable to correctly tune the MySQL engine.
If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Database Design and Tuning.
Maximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage & Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook.
Understand MySQL's features, technical architecture, subsystems, and commands
Make database design decisions that optimizre performance, storage, and reliability
Write complex queries using joins, subqueries, and views
Group SQL statements into transactions and execute them atomically
Build and use sophisticated stored procedures and functions
Automate database operations with triggers and scheduled events
Import and export data in different formats, includiong SQL, CSV, and XML
Optimize server and query performance
Administer a secure, high availability MySQL RDBMS
Manage users and control access
Perform database maintenance, replication, backup, and recovery
Vikram Vaswani is the founder and CEO of Melonfire (www.melonfire.com), a consultancy firm with special expertise in open-source tools and technologies. His previous books include MySQL: The Complete Reference, PHP: A Beginner's Guide, and PHP Programming Solutions.
Product Description: For many people, the main reason for learning a scripting language like PHP is because of the interaction with databases it can offer. In this tutorial I will show you how to use PHP and the MySQL database to store information on the web and include it into your website. Before you read this tutorial you should have at least a basic knowledge of how to use PHP. If you do not yet know PHP, I suggest that you read our PHP tutorial before continuing.
Answers 2000 Limited has no opinion about any stories or content of, or
views expressed in, any linked news resource or website.
Information about companies, organizations, products and services
was believed to be correct at the time it was first published on this website,
but may out of date by the time you read this website. For current
information about any company or organization,
readers are advised to check with the applicable company or organization.
Answers 2000 Limited expresses no opinion about any company or
organization (including expressing no opinion on any investments in, with, or relating to, any company or organization),
product or service. This website is not intended as investment or
In Association With Amazon.com Answers 2000 Limited is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Our company's websites' content (including this website's content) includes advertisements for
our own company's websites, products, and services,
and for other organization's websites, products, and services.
In the case of links to other organization's websites,
our company may receive a payment, (1) if you purchase products or services,
or (2) if you sign-up for third party offers, after following links from this website.
Unless specifically otherwise stated, information about other organization's products and services,
is based on information provided by that organization,
the product/service vendor, and/or publicly available information - and should
not be taken to mean that we have used the product/service in question.
Additionally, our company's websites contain some adverts which we are paid
to display, but whose content is not selected by us, such as Google AdSense ads. For more
detailed information, please see Advertising/Endorsements Disclosures
constitutes consent for this. For details, please see Privacy.