Blog

Fixing MySQL Workbench Issues on macOS Mojave
Posted on August 5, 2019 in MySQL by Matt Jennings

If you are having problems opening a new connection in MySQL Workbench in macOS Mojave, follow the commands below (per these …

Read more

MySQL Queries Cheat Sheet
Posted on December 31, 2017 in MySQL by Matt Jennings

Knowledge gained from Learn SQL and MySQL in 3 Hours by Umang Shah (Udemy class).

super_market (database and …

Read more

Post to a MySQL Database Using a jQuery AJAX Form with CodeIgniter
Posted on July 10, 2015 in AJAX, CodeIgniter, MVC, MySQL, PHP by Matt Jennings

<?php if ( ! defined(‘BASEPATH’)) exit(‘No direct script access allowed’);

class Quote extends CI_Model
{

public function all()
…

Read more

MySQL LEFT JOIN and WHERE Example
Posted on July 7, 2015 in MySQL by Matt Jennings

Consider a user_quotes MySQL database with the three tables below:

users
quotes
favorites (one to many relationship with the users and quotes tables)

The …

Read more

MySQL Subquery Example
Posted on July 7, 2015 in MySQL by Matt Jennings

Consider a user_quotes MySQL database with the three tables below:

users
quotes
favorites (one to many relationship with the users and quotes tables)

The …

Read more