Weekly Reading for Week of 09-08-2018

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…


Advertisements

The LIMIT clause – Examples with MySQL.

Don’t want all records returned in the query results? Maybe you need pagination for a results set or web app… Many of these requirements can be taken of by applying the LIMIT clause to your query. Let’s look at a few examples here in MySQL…

Like open-source SQL? Me too! Read on!

The AUTO_INCREMENT column attribute in MySQL – A beginning perspective.

AUTO_INCREMENT. Without a care in the world, we reach for this attribute in MySQL. Quicker than any snake, we slap it to the PRIMARY KEY column in a CREATE TABLE command. Or ‘tic’ the check box in phpMyAdmin and carry on like nobody else’s business. What does AUTO_INCREMENT do? What is it used for? Is its value always the next incremental number? Can we capture, manipulate, and use it to do our bidding? Those are all great questions I would like to know myself. Let’s find out…

Like what you are reading? Keep a going!

Code snippet syntax highlighting in Gutenberg via shortcodes – Continued learning…

With Gutenberg coming full-on to WordPress core soon, I’ve committed to try to learn all I can about it. I may as well face the fact that I am going to have to use it. Honestly, so far, I have not found it to be all that bad.

Learning Gutenberg also? Me too! Keep reading…