MySQL Tutorials & Guides

MySQL 17 Mar 2013 35067

Country Lookup by IP address CSV

So this is an article to serve as documentation for one of the data sources available to download for FREE from this site.

Read note →

MySQL 05 Feb 2013 38447

Export/Import Database using MySQL Workbench

This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database.

Read note →

MySQL 03 Feb 2013 25177

Quickly update all content in mySQL database replacing a string

This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author.

Read note →

MySQL 01 Feb 2013 41663

Access MySQL databases using Oracle SQL Developer

So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.

Read note →

MySQL 11 Jan 2013 24219

Delete related records from multiple tables

So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements.

Read note →

MySQL 13 Dec 2012 25432

Error 1065: Query was Empty

In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common.

Read note →

MySQL 27 Nov 2012 25296

Generate Academic Calendar using MySQL

We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers.

Read note →

MySQL 27 Apr 2012 37513

MySQL: Display Users and Duration in Matrix Timesheet

Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00 00:00 02:00 36:00 Myself 07:30 07:30 07:30 07:30 07:00 00:00 00:00 37...

Read note →

MySQL 26 Apr 2012 26855

MySQL day of week ending on Friday

Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday.

Read note →