MySQL

Master MySQL with Excellent Free Books

Free Books

MySQL is an open source relational database management systems. It is a multi-user, multi-threaded database management system. MySQL is especially popular on the web, being one element of the popular LAMP development platform (Linux, Apache HTTP Server, MySQL, and PHP programming language).

MySQL is useful for small and large databases containing billions of records and terabytes of data in hundreds of thousands of tables. It’s designed to be easy to use, and its scalability and flexibility make it suitable for almost any application.

The MySQL development project releases its source code available under the GNU General Public License, as well as under a variety of proprietary agreements.

The following MySQL books warrant our recommendation.

MySQL Notes for Professionals

MySQL Notes for Professionals

(199 pages)

This MySQL Notes for Professionals book is compiled from Stack Overflow Documentation.

Chapters cover:

  • Getting started with MySQL
  • Data Types
  • SELECT
  • Backticks
  • NULL
  • Limit and Offset
  • Creating databases
  • Using Variables
  • Comment MySQL
  • INSERT
  • DELETE
  • UPDATE
  • ORDER BY
  • Group By
  • Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause
  • Joins
  • JOINS: Join 3 table with the same name of id
  • UNION
  • Arithmetic
  • String operations
  • Date and Time Operations
  • Handling Time Zones
  • Regular Expressions
  • VIEW
  • Table Creation
  • ALTER TABLE
  • Drop Table
  • MySQL LOCK TABLE
  • Error codes
  • Stored routines (procedures and functions)
  • Indexes and Keys
  • Full-Text search
  • PREPARE Statements
  • JSON
  • Extract values from JSON type
  • MySQL Admin
  • TRIGGERS
  • Configuration and tuning
  • Events
  • ENUM
  • Install Mysql container with Docker-Compose
  • Character Sets and Collations
  • MylSAM Engine
  • Converting from MylSAM to InnoDB
  • Transaction
  • Log files
  • Clustering
  • Partitioning
  • Replication
  • Backup using mysqldump
  • mysqlimport
  • LOAD DATA INFILE
  • MySDL Unions
  • MySQL client
  • Temporary Tables
  • Customize PS1
  • Dealing with sparse or missing data
  • Connecting with UTF-8 using various programming languages
  • Time with subsecond precision
  • One to Many
  • Server Information
  • SSL Connection Setup
  • Create New User
  • Security via GRANTs
  • Change Password
  • Recover and reset the default root password for MySQL 5.7+
  • Recover from lost root password
  • MySQL Performance Tips
  • Performance Tuning

The text is released under the Creative Commons BY-SA license.

MySQL

MySQL

By Wikibooks (82 pages)

Chapters cover:

  • Introduction
  • MySQL Practical Guide
  • Databases manipulation
  • Language
  • Language/Browsing the databases
  • Language/Specifying names
  • Language/Definitions: what are DDL, DML and DQL?

Permission is granted to copy, distribute, and/or modify this document under the terms of the Creative Commons Attribution-ShareAlike 3.0 License.

Intrusion Detection

Intrusion Detection with SNORT: Using SNORT, Apache, MySQL, PHP, and ACID

By Rafeeq Ur Rehman (275 pages)

Snort is an open source Network Intrusion Detection System (NIDS) which is available free of cost.

Chapters cover:

  • What is Intrusion Detection?
  • Installing Snort and Getting Started
  • Working with Snort Rules
  • Plugins, Preprocessors and Output Modules
  • Using Snort with MySQL
  • Using ACID and SnortSnarf with Snort
  • Miscellaneous Tools

This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later.

MySQL Reference

MySQL 8.0 Reference Manual

By MySQL Documentation Team (5480 pages)

This is the MySQL Reference Manual. It documents MySQL 8.0 through 8.0.15. It is official documentation.

You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You cannot publish or distribute this documentation in any form or on any media

We have published a series covering the best open source programming books for popular languages. Read them here.

PROGRAMMING LANGUAGE PROFILES

Ada, Assembly, Awk, Bash, C, C++, C#, Clojure, CoffeeScript, ECMAScript, Erlang, Forth, Fortran, Go, Haskell, HTML, Java, JavaScript, LaTeX, Lisp, Logo, Lua, OCaml, Pascal, Perl, PHP, Prolog, Python, R, Ruby, Rust, Scala, Scheme, Scratch, SQL, Swift, TeX, VimL

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.