MySQL Tutorials & Guides

MySQL 17 Mar 2013

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 → 35,129 hits

MySQL 05 Feb 2013

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 → 38,517 hits

MySQL 03 Feb 2013

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 → 25,245 hits

MySQL 01 Feb 2013

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 → 41,730 hits

MySQL 11 Jan 2013

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 → 24,284 hits

MySQL 13 Dec 2012

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 → 25,493 hits

MySQL 27 Nov 2012

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 → 25,359 hits

MySQL 27 Apr 2012

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 → 37,573 hits

MySQL 26 Apr 2012

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 → 26,913 hits