Below is an example how to insert multiple values/rows into a table using a single insert statement shortcut. Versus individually listing out each insert statement
Several Ways to Run Queries from Bash
In some of these examples, particularly the remote server I’ve included usernames and passwords, but you might not need it locally, depending on your mysql
How to Insert on Duplicate Key Update (an upsert)
This example of a upsert, an on duplicate key insert statement in MySQL. What it does is if the table zipcode_population has a unique index
Function to Remove Dollar Signs and Commas From a Number
I needed a function to turn a string value dollar with commas into a decimal I could insert into MySQL. This function below will take
Learn PDO In 30 Seconds
phpdelusions is my main go to guide for everything php/pdo. But to just get started with PDO you really only need to know a few
