Here are some notes I’ve been making from the book SQL Cookbook Query Solutions and Techniques for All SQL Users (Anthony Molinaro, Robert de Graaf), specifically from chapter 5.

SELECT table_name FROM information_schema.tables WHERE table_schema = ‘SMEAGOL’

This is a means of …

Here are some notes I’ve been making from the book SQL Cookbook Query Solutions and Techniques for All SQL Users (Anthony Molinaro, Robert de Graaf), specifically from chapter 4.

Chapter 4

Inserting a new record has the following format:

INSERT INTO tableName (columnNameOne, …

Here are some notes I’ve been making from the book SQL Cookbook Query Solutions and Techniques for All SQL Users (Anthony Molinaro, Robert de Graaf), specifically from chapter 3.

Chapter 3

To return data stored from more than one table, when they have common data types, use UNION ALL. It …