FOREIGN KEY Referential Actions in MySQL – with examples.

In FOREIGN KEYS in MySQL with examples. I discussed establishing referential integrity between multiple tables sharing related and associated data using a FOREIGN KEY. However, the included syntax examples were not completely covered. In particular, the actual definition of the referential action. In this blog post I will continue with this concept and cover those definitions, their meanings, and example use…

You’re headed for more great MySQL blogging…

Advertisements

FOREIGN KEYS in MySQL with examples.

Oftentimes, we use multiple tables in a database to meet normalization best practices. Among the normal forms, we also must ensure some type of integrity for related data spread out between multiple tables. A FOREIGN KEY, along with specific constraints, can be used for this…

Like MySQL? Me too! You’re in the right place! Keep reading…

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!

Example uses of MySQL SHOW syntax.

In this blog post, I will look at a few handy uses of the SELECT and SHOW commands to retrieve information in MySQL. SHOW returns useful information on databases, tables, etc…

Interested? Keep reading…