Help with SQL commands to interact with a MySQL database
- Mac /usr/local/mysql/bin
 - Windows /Program Files/MySQL/MySQL version/bin
 - Xampp /xampp/mysql/bin
 
| [ | |
| { | |
| "abbr": "AL", | |
| "name": "Alabama", | |
| "capital": "Montgomery", | |
| "lat": "32.361538", | |
| "long": "-86.279118" | |
| }, | |
| { | |
| "abbr": "AK", | 
| <div id="app"> | |
| <h4 class="head"> Application</h4> | |
| <div class="container"> | |
| <!-- <div class="img-container"> | |
| <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOEAAADhCAMAAAAJbSJIAAAA1VBMVEX///9BuIM1SV4lsncQMUxCvoU0PVtBu4Q1R10+t4E1RV05tn80QVw0Q1w0P1s0tX3x+vef2b54y6Tp9/G24s3i9OxPvozD59bb8ObP7N6s3seGz65cwpSV1Lc/oHxIvIlwyJ87e283UWI8g3I6bWs+mHlBr4E5Zmg8iXR/zalAqX84W2VZwZI+nnuc17tBsoI+kXc3VmMlO1TH09Pl7ex3jZNIZXANNU2fsLMeRFYTO1A6dG0Aq2kOIEhsgooCKkixwMHX4OA0Mlkil25adH2JnKFegISv2nx/AAAHGElEQVR4nO2ba1vUOhRGyww4FxhmRAVUUMQLCio3ARG8HfH8/590HvGAVHabld3dNpkn67M2TTMm27XfZFkikUgkEolEIpFIJBKJRCKRSCQSiUQikVCwet5F/Pg86+TrsdfQx1/dj/z8g73e+WrxOG/mZwhzL4YdJ7OHHhM8nHU/cPhiDr3d/OOSgSZd9IyZ3TvuF+qfeszwtO9+4OIue7nupGykR2P0kLnnI/cbHXzEE/x44H7c6DlbwvGj8rHYZ5rpdcBHPyn9mDeYnLif1u/04Ls5BnvIfqe9l4vuGQ6/wBl+Af+sF1+yGXYfukbbgJvNDljE2e9ogt/BNtPfgdvMhnO4e3ARt8lms4NmSD7WnW24hPfc463DRTwjm803MMFvZJs5g0u4Tj7peIAeNrPgfrHOJzDeJ/CcBfZKgzGZYHafnRi912CKBz+dw/0ES7jwmv1Gx/fRDLNltohzm2Sz+eAY7APZZjbZb3SwzCaYrcLN5h05MS4cg12Qk+Id3GZKCtI | 
| <dialog open> | |
| <form method="dialog"> | |
| <p>Do you want to confirm your action?</p> | |
| <div class="right"> | |
| <input class="btn" type="submit" value="Ok" /> | |
| <input class ="btn" type="submit" value="Cancel" /> | |
| </div> | |
| </form> | |
| </dialog> | 
| const {spawnSync} = require('child_process') | |
| const inquirer = require('inquirer') | |
| const glob = require('glob') | |
| async function go() { | |
| const files = glob | |
| .sync('src/+(exercise|final)/*.+(js|ts|tsx)', { | |
| ignore: ['*.d.ts'], | |
| }) | |
| .map(f => f.replace(/^src\//, '')) | 
| // Youtube tutorial here: https://youtu.be/LDgPTw6tePk | |
| // These functions are designed to be exported, but you could create a class instead. See tutorial video. | |
| // #1 proper case | |
| export const properCase = (string) => { | |
| return `${string[0].toUpperCase()}${string.slice(1).toLowerCase()}`; | |
| }; | 
| // Youtube tutorial here: https://youtu.be/LDgPTw6tePk | |
| // These functions are designed to be exported, but you could create a class instead. See tutorial video. | |
| // #1 proper case | |
| export const properCase = (string) => { | |
| return `${string[0].toUpperCase()}${string.slice(1).toLowerCase()}`; | |
| }; | 
| from apispec import APISpec | |
| from apispec.ext.marshmallow import MarshmallowPlugin | |
| from apispec_webframeworks.flask import FlaskPlugin | |
| from flask import Flask, jsonify, render_template, send_from_directory | |
| from marshmallow import Schema, fields | |
| from werkzeug.utils import secure_filename | |
| app = Flask(__name__, template_folder='swagger/templates') | 
| // Basic Types | |
| let id: number = 5 | |
| let company: string = 'Traversy Media' | |
| let isPublished: boolean = true | |
| let x: any = 'Hello' | |
| let ids: number[] = [1, 2, 3, 4, 5] | |
| let arr: any[] = [1, true, 'Hello'] | |
| // Tuple |