Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...

Tom demos table joins, shell scripts for repetitive tasks and using "exec" to run commands inside a container from the host system. In my previous article on running applications on Docker, I deployed ...

PhpMyAdmin is used as the backend database interface for a number of leading content management systems deployed by businesses, including WordPress, Joomla and Drupal. Thanks to the phpMyAdmin Web ...

I am updating the family website, and I've run into a snag with some SQL. I had this working in version 1 of the website, but it required two trips to the DB because I was pulling back a listing of ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...