MySQL: Learn By Coding


The Web App Path book can be hard to follow if you aren't familiar with MySQL. That's where this book comes in.

We walk you through everything you need to know to start creating and querying your database using MySQL.

And we don't waste your time by padding out the book with unnecessary terminology or history. If you read this book, you'll know everything you need to get starting using MySQL.

You can buy the book at Amazon.

Table of Contents

  • Introduction
  • Installing MySQL
  • Command Line
  • Creating a Table
  • Inserting, Updating, and Deleting
  • Selecting Data
  • Ordering and Limiting
  • Relationships
  • Joining Tables
  • Operations
  • Conclusion


In 2016, I wrote a book called The Web App Path. It showed you how to use web technologies, such as HTML, CSS, PHP, JavaScript, and MySQL, to create a web app.

I didn't cover these technologies in great detail though. I assumed that you already knew them or could learn them on your own.

Since then, I've decided to cover the basics in more detail. That's what I'm doing in this “Learn by Coding” series. Previously, I covered PHP and JavaScript. In this book, I'm going to show you how to use MySQL.

I'm not going to cover every inch of MySQL. Instead, I'm going to show you enough that you can get started creating web applications or websites. After you read this book, you'll have a good grounding in MySQL.

I also realize that Kindle is not the best platform for programming books. It can be hard to read the MySQL code. That's why we've included the code for the longer queries in a special code repository, which you can find at

Source Code