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…
A previous blog post I wrote, INSERT with SELECT statement for columns with FOREIGN KEY constraint in MySQL with examples, we visited using
SELECT syntax adding records to one table, honoring
FOREIGN KEY constraints in another. Constantly retyping that
SELECT for each
INSERT can be automated by ‘wrapping’ it up a function and that will be the focus for this blog post.
MySQL Stored Procedures and Functions enable database devs the ability to wrap useful bits of code in a nice little ‘package’ for reuse. In this blog post, I will provide a simple example to get you started on incorporating stored procedures into your own daily work flow.
Note: All data, names or naming found within the database presented in this post, are strictly used for practice, learning, instruction, and testing purposes. It by no means depicts actual data belonging to or being used by any party or organization.
In this blog post, we’ll look at an example of
SELECT syntax to honor those
FOREIGN KEY constraints we have in place that ensure referential integrity between rows in separate tables.
I love learning and sharing interesting things as I continue to forge SQL database developer skills.
USING clauses are similar when ployed with
But I think they are far from identical.