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
from json import load as json_load | |
with open("sample_input.json") as input_fh: | |
people = json_load(input_fh) | |
for person in people["people"]: | |
if person["age"] >= 30: | |
print("Name: {name}, City: {city}".format(name=person["name"], city=person["city"])) |
from csv import reader as csv_reader | |
with open("sample_input.csv") as input_fh: | |
people = csv_reader(input_fh) | |
headers = next(people) | |
for row in people: | |
person = (dict(zip(headers, row))) | |
if int(person["age"]) >= 30: | |
print("Name: {name}, City: {city}".format(name=person["name"], city=person["city"])) |
#! /bin/bash | |
# ECHO COMMAND | |
# echo Hello World! | |
# VARIABLES | |
# Uppercase by convention | |
# Letters, numbers, underscores | |
NAME="Bob" | |
# echo "My name is $NAME" |
#! /bin/bash | |
# ECHO COMMAND | |
# echo Hello World! | |
# VARIABLES | |
# Uppercase by convention | |
# Letters, numbers, underscores | |
NAME="Bob" | |
# echo "My name is $NAME" |