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.
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: The Oracle Certified Professional MySQL 5.6 Admin certification is intended for candidates relatively new to using the MySQL database server version 5.6. The exam 1Z0-883 covers database admin related concepts and the relevant utilities. The topics covered include: MySQL Architecture MySQL Server Installation, Configuration and Maintenance MySQL Security Diagnostic Data and Metadata Sources in MySQL Optimizing MySQL Performance Backups and Recovery in MySQL High Availability Techniques for MySQL This ExamFOCUS book focuses on the more difficult topics that will likely make a difference in exam results. This is NOT an ABC guide to MySQL book.
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
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.
Product Description: Practical PHP and MySQL Website Databasesis a project-oriented book that demystifies building interactive, database-driven websites. The focus is on getting you up and running as quickly as possible. In the first two chapters you will set up your development and testing environment, and then build your first PHP and MySQL database-driven website. You will then increase its sophistication, security, and functionality throughout the course of the book. The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MySQL to create powerful database-driven websites. Each project is fully illustrated, so you will see clearly what you are building as you create your own database-driven website. You will build a form for registering users, and then build an interface so that an administrator can view and administer the user database. You will create a message board for users and a method for emailing them. You will also learn the best practices for ensuring that your website databases are secure. Later chapters describe how to create a blog, a product catalog, and a simple e-commerce site. You will also discover how to migrate a database to a remote host. Because you are building the interactive pages yourself, you will know exactly how the MySQL and PHP work, and you will be able to add database interactivity to your own websites with ease.
Product Description: PHP and MySQL Web Development, Fourth Edition The definitive guide to building database-drive Web applications with PHP and MySQL
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.
PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.
This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.
The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.
TABLE OF CONTENTS Part I: Using PHP 1 PHP Crash Course 2 Storing and Retrieving Data 3 Using Arrays 4 String Manipulation and Regular Expressions 5 Reusing Code and Writing Functions 6 Object-Oriented PHP 7 Error and Exception Handling
Part II: Using MySQL 8 Designing Your Web Database 9 Creating Your Web Database 10 Working with Your MySQL Database 11 Accessing Your MySQL Database from the Web with PHP 12 Advanced MySQL Administration 13 Advanced MySQL Programming
Part III: E-Commerce and Security 14 Running an E-Commerce Site 15 E-commerce Security Issues 16 Web Application Security 17 Implementing Authentication with PHP and MySQL 18 Implementing Secure Transactions with PHP and MySQL
Part IV: Advanced PHP Techniques 19 Interacting with the File System and the Server 20 Using Network and Protocol Functions 21 Managing the Date and Time 22 Generating Images 23 Using Session Control in PHP 24 Other Useful Features Part V: Building Practical PHP and MySQL Projects 25 Using PHP and MySQL for Large Projects 26 Debugging 27 Building User Authentication and Personalization 28 Building a Shopping Cart 29 Building a Web-Based Email Service 30 Building a Mailing List Manager 31 Building Web Forums 32 Generating Personalized PDF Documents 33 Connecting to Web Services with XML and SOAP 34 Building Web 2.0 Applications with Ajax
Part VI: Appendixes Appendix A: Installing PHP and MySQL Appendix B: Web Resources
The Essential Guide to Scaling Your Business Solution
Written by Oracle ACE Director and MySQL expert Ronald Bradford, with coauthor Chris Schneider, Effective MySQL: Replication Techniques in Depth describes what is needed to understand and implement MySQL replication to build scalable solutions. This book includes detailed syntax examples to demonstrate the features, options, and limitations of native MySQL replication. Providing an evaluation of various new replication features and additional third-party product implementations, this Oracle Press guide helps to ensure your MySQL environment can support the various high-availability needs of your business.
Master the strengths and limitations of native asynchronous replication in a MySQL topology
Identify the important features to improve replication for growing business requirements
Recognize the key business factors to determine your optimal highavailability needs
Understand the benefits of using MySQL replication for failover scenarios
Identify the key configuration variables and SQL commands affecting master/ slave replication
Learn about the advancements in replication techniques provided by new products, including Tungsten Replicator and Galera
Optimize your replication management with various utilities and toolkits
Find additional detailed information and presentations at EffectiveMySQL.com.
Product Description: This is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. All complicated concepts are broken down to be very easy to understand. Everything in the book is designed to help you learn and use MySQL for Python to address your programming needs in the fastest way possible. This book is meant for intermediate users of Python who want hassle-free access to their MySQL database through Python. If you are a Python programmer who wants database-support in your Python applications, then this book is for you. This book is a must-read for every focused user of the MySQL for Python library who wants real-world applications using this powerful combination of Python and MySQL.
This book teaches you how to work with MySQL - a popular relational database management system. MySQL is a popular choice of a database system for web applications, with even large websites like YouTube, Facebook and Twitter making use of it.
You will learn how to download and install MySQL on your Windows or Linux system. You will learn how to access MySQL through the command line or GUI, how to create a database, how to query a database, sort results, and much more. I will also guide you through some more advanced MySQL topics, such as how to use MySQL functions, aliases, keys, and such. I will also show you how you can backup and restore your databases.
The topics covered in this book are:
what MySQL is and how to install it on Windows or Linux.
the SQL syntax, executing basic commands: how to create a database, how to create a table, and how to create a user.
SQL commands used to manage a database: how you can insert new records in a table, modify a table, update the contents of a field.
Amazon Web Services Released: 2016-10-31 Kindle Edition (25 pages)
Product Description: October 2016 This whitepaper discusses some of the important factors affecting the performance of self-managed export/import operations in Amazon Relational Database Service (Amazon RDS) for MySQL and Amazon Aurora. Although many of the topics are discussed in the context of Amazon RDS, performance principles presented here also apply to the MySQL Community Edition found in self-managed MySQL installations. This documentation is offered for free here as a Kindle book, or you can read it in PDF format at https://aws.amazon.com/whitepapers/.
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.