Chad Conway chadsconway

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

C-x C-c - quit
C-x C-s - save buffer
C-x C-f - open file
C-x b buffer name - switch to open buffer
C-g - cancel
C-x k - close current buffer
C-h a command name - look up docs for command
M-x command name - execute command
C-x u - undo
C-/ - undo

CSS Border Animation

A Pen by Chad S Conway on CodePen.

License.

Using the JSON Format

The binary data format pickle uses is specific to Python. To improve the interoperability between different programs the JavaScript Object Notation (JSON) provides an easy-to-use and human-readable schema, and thus became very popular.

The following example demonstrates how to write a list of mixed variable types to an output file using the json module. In line 4 the basic list is defined. Having opened the output file for writing in line 7, the dump() method stores the basic list in the file using the JSON notation.

import json

# define list with values
basicList = [1, "Cape Town", 4.6]

	/* (A) WRAPPER */
	#pop-up {
	position: fixed;
	top: 50px;
	right: 50px;
	z-index: 999;
	width: 400px;
	background: rgba(10, 10, 10, 0.8);
	visibility: hidden;
	opacity: 1;

	<!DOCTYPE html>
	<html>
	<head>
	<title>EaselJS demo: Inheritance</title>
	<link href="./demo.css" rel="stylesheet" type="text/css" />
	<script src="./easeljs-NEXT.js"></script>
	<script src="./button.js"></script>
	<script>
	var stage, holder;
	function init() {

	var x, i, l;
	x = document.getElementsByTagName("*");
	l = x.length;
	for(i = 0; i < l; i++) {
	document.write(x[i].tagName + "<br>");
	}

	import React from 'react';

	export default function Editor() {
	return (
	<div>
	Editor
	</div>
	);
	}

	<!-- Document Typ0e Definition -->
	<!DOCTYPE html PUBLIC "-//W3C/DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<!-- Starting html tag -->
	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>XHTML Trnasitional Template</title>
	</head>
	<body>
	<h1>some body</h1>

	.container {
	display: grid;
	overflow-x: hidden;
	}

	.gridtext {

	font-size: 20px;
	color: white;
	text-align: center;