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).

Starting 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

Model Example

<?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…