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

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!