Dino DinoSourcesRex

## mysql_cheat_sheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                DinoSourcesRex
                / mysql_cheat_sheet.md
            
            
              Created
              March 25, 2021 19:27
                — forked from bradtraversy/mysql_cheat_sheet.md
            
              
                MySQL Cheat Sheet
              
          
    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


## app.js
const { performance } = require("perf_hooks");
const _ = require("lodash");
const http = require("http");
const jp = require("jsonpath");

const hostname = "127.0.0.1";
const port = 3000;

const server = http.createServer((req, res) => {});

## IncrementPipelineVariable.ps1
# In the Phase definition make sure to check "Allow scripts to access the OAuth token" otherwise this will fail.
$VariableName = "ProjectBuildNumber"

$defId = $env:SYSTEM_DEFINITIONID
# Uses built in environment variables to create the token and api call for us
# If you want to hit a release instead just change "build/definitions/" to "release/definitions"
$url = "$env:SYSTEM_TEAMFOUNDATIONCOLLECTIONURI$env:SYSTEM_TEAMPROJECTID/_apis/build/definitions/" + $defId + "?api-version=5.0"
Write-Host "URL: $url"
# Get the build definition
$pipeline = Invoke-RestMethod -Uri $url -Headers @{

## code_extensions.sh
code --list-extensions | xargs -L 1 echo code --install-extension
	const { performance } = require("perf_hooks");
	const _ = require("lodash");
	const http = require("http");
	const jp = require("jsonpath");

	const hostname = "127.0.0.1";
	const port = 3000;

	const server = http.createServer((req, res) => {});
	# In the Phase definition make sure to check "Allow scripts to access the OAuth token" otherwise this will fail.
	$VariableName = "ProjectBuildNumber"

	$defId = $env:SYSTEM_DEFINITIONID
	# Uses built in environment variables to create the token and api call for us
	# If you want to hit a release instead just change "build/definitions/" to "release/definitions"
	$url = "$env:SYSTEM_TEAMFOUNDATIONCOLLECTIONURI$env:SYSTEM_TEAMPROJECTID/_apis/build/definitions/" + $defId + "?api-version=5.0"
	Write-Host "URL: $url"
	# Get the build definition
	$pipeline = Invoke-RestMethod -Uri $url -Headers @{