Archive for the ‘sql’ Category

Move a WordPress Site by Moving the Database and Files

Posted on: No Comments
The following is a guest post by Erez Elias. Erez recently attended a WordCamp and wrote to me inspired to write something about WordPress. We agreed this was an interesting topic, and one I've been meaning to document myself as it's something I've don...

3 More Joins You Should Be Familiar With

Posted on: No Comments
There are many ways to JOIN data from two database tables and filter the information you require. Craig Buckler wrote a popular piece on understanding JOINs; namely INNER, LEFT, RIGHT, and FULL OUTER. This article is an extension of that one. Let’s r...

Quick Tip: How to Permanently Change SQL Mode in MySQL

Posted on: No Comments
I was working on a legacy project recently and needed to import some data from MySQL 5.5. All the queries in the code worked perfectly in MySQL 5.5, so I assumed an upgrade to 5.7 would be seamless. Not so. First I got errors due to DateTime columns b...

SQL vs NoSQL: How to Choose

Posted on: No Comments
In the previous article we discussed the primary differences between SQL and NoSQL databases. In this follow-up, we'll apply our knowledge to specific scenarios and determine the best option. To recap: SQL databases: store related data in tables requi...