Ken Kentaro-Furukawa

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

	-- First method
	SELECT * FROM t1
	LEFT JOIN t2 ON t1.id = t2.id
	UNION
	SELECT * FROM t1
	RIGHT JOIN t2 ON t1.id = t2.id

	-- Second Method
	-- The query above works for special cases where a FULL OUTER JOIN operation would not produce any duplicate rows.
	-- The query above depends on the UNION set operator to remove duplicate rows introduced by the query pattern.

	// Filename: HttpServer.cs
	// Author: Benjamin N. Summerton <define-private-public>
	// License: Unlicense (http://unlicense.org/)

	using System;
	using System.IO;
	using System.Text;
	using System.Net;
	using System.Threading.Tasks;

	global $wp;
	$current_url = home_url(add_query_arg(array(),$wp->request));