Tag: SQL
-
How to Back Up Your Laravel Homestead Databases
Read more…: How to Back Up Your Laravel Homestead DatabasesToday 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…
-
Bulk Clearing Expiration Dates in Restrict Content Pro
Read more…: Bulk Clearing Expiration Dates in Restrict Content ProAt 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.
-
Many-to-Many Relationships in Relational Data Models
Read more…: Many-to-Many Relationships in Relational Data ModelsToday I learned about Many-to-Many relationships in relational data models
-
Excel formulas to combine columns and convert time, More SQL functions
Read more…: Excel formulas to combine columns and convert time, More SQL functionsTIL how to concatenate columns and convert time in Excel and some more SQL functions.
-
Aliases in SQL and Sorting Tables with jQuery
Read more…: Aliases in SQL and Sorting Tables with jQueryTIL how to make aliases for tables in SQL and how to sort tables with jQuery
-
Hiding Categories from the Jekyll Paginator, Unless, and Insert statements
Read more…: Hiding Categories from the Jekyll Paginator, Unless, and Insert statementsTIL how to hide my TIL posts from the front page of my site, the Unless tag, and inserting mysql with PHP.
-
Connecting and Writing to MySQL with PHP
Read more…: Connecting and Writing to MySQL with PHPTIL the basics of connecting to a MySQL database and creating tables in PHP.