SQL – Chuck Grimmett

How to Back Up Your Laravel Homestead Databases

Today I upgraded from Homestead 4.0.0 to 5.0.1 so I could test my sites in PHP 7. That was a major upgrade and a number of things changed, so I decided that I needed to back up my databases before I did the upgrade. I’d only ever dumped specific databases before, but TIL how to dump them all at once. Here is how to do that in Laravel Homestead.

January 24, 2018

Homestead, PHP, SQL
Bulk Clearing Expiration Dates in Restrict Content Pro

At Praxis we use Restrict Content Pro as the membership system for our curriculum portal. We decided that all grads get access for life, not just during the program. So, I needed a way to clear over 200 member expiration dates. Here is how I accomplished that task with SQL.

December 4, 2017

SQL, WordPress
Many-to-Many Relationships in Relational Data Models

Today I learned about Many-to-Many relationships in relational data models

June 30, 2016

Data Science, SQL
Excel formulas to combine columns and convert time, More SQL functions

TIL how to concatenate columns and convert time in Excel and some more SQL functions.

March 10, 2016

Apps, Excel, SQL
Aliases in SQL and Sorting Tables with jQuery

TIL how to make aliases for tables in SQL and how to sort tables with jQuery

March 9, 2016

Javascript, SQL
Hiding Categories from the Jekyll Paginator, Unless, and Insert statements

TIL how to hide my TIL posts from the front page of my site, the Unless tag, and inserting mysql with PHP.

March 3, 2016

Jekyll, Liquid, PHP, SQL
Connecting and Writing to MySQL with PHP

TIL the basics of connecting to a MySQL database and creating tables in PHP.

March 2, 2016

PHP, SQL

Tag: SQL