Tag: sql

Published on 22 November

A Beginner’s Introduction to SQL & MySQL

By Bob Hensley , In Administration, Database, Languages, SQL

Your Data Lives Somewhere Databases, and the very definition of one come in all shapes and sizes. But ultimately every definition has the same roots: a system with which data can be stored persistently and reliably. Persistence (it’s not lost when the application closes or the machine shuts down) and reliability (you will be able to retrieve as needed …

Published on 02 August

Stored Routines: Word Filtering Inside the Database

By Bob Hensley , In Administration, Database, Databases, MySQL, SQL

Please note: This article was written in late 2010. Before MariaDB. Before MySQL 5.5 even released. What you read below may no longer work, or require modifications to make work. MySQL Stored Routines: Another Useful Scenario In a past guide I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. …