CodeUnit How to Duplicate a Table in FlameRobin October 3, 2011 by Craig Lotter No Comments FlameRobin is a lightweight, cross-platform database administration tool for Firebird databases. It is also NOT one of my favourite tools to use because of its... Read More
CodeUnit SQL: Finding Duplicate Rows based on Multiple Columns June 25, 2010 by Craig Lotter No Comments Locating duplicate rows based on multiple column values with SQL turns out to be a fairly simple exercise. Read More
CodeUnit SQL: Finding all Duplicate Records in a Table March 3, 2010 by Craig Lotter No Comments Sometimes it is quite handy to see which records based on a particular key appear more than once in a database. The trick here is... Read More
Tips, Tricks and Tutorials MySQL: How to Duplicate a Table September 10, 2009 by Craig Lotter No Comments Well funnily enough, it's actually pretty damn simple. The CREATE TABLE IF NOT EXISTS phrase is key here and combining this with a select statement... Read More