One of the most popular questions from my MySQL courses is how to connect to MySQL from the command prompt. Here are the simple steps I use.
Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management
I was reading Dr. W. Edwards Deming’s 14 principles of Total Quality Management. Here they are, with a few resources I collected on the subject.
MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET
The MySQL function FIND_IN_SET searches for a value within comma separated values and returns its position. It can also replace an IN clause.
SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer
Can you retrieve the last inserted rows from a table with no identity or date column? Here is my chat with Dustin on a question with no good answer.
MySQL – Pattern Matching Comparison Using Regular Expressions with REGEXP
MySQL supports pattern matching using regular expressions with REGEXP. I show how to use ^, $, | and square brackets to match values in a table.
MySQL – How to do Straight Join in MySQL?
How does a straight join in MySQL work? STRAIGHT_JOIN is like an INNER JOIN but always reads the left table first. Here is a simple items and sales example.
MySQL – How to do Natural Join in MySQL? – A Key Difference Between Inner Join and Natural Join
MySQL supports NATURAL JOIN, which maps matching columns from both tables on its own. I show how it works and the key difference from INNER JOIN.