-
-
What, who, where am I?!?
Craig Lotter is a web developer based in Gordon's Bay, South Africa, who seems completely incapable of shaking off that pesky inner child within, the one that forces him to love all things animated or hand drawn.
The Rugged Rock of Craig contains snippets of his life, popular culture and all the important things like anime, manga, games and comic books. The CodeUnit of Craig on the other hand contains the more serious stuff like code snippets and tutorials, while the House of C chronicles his foray into the world of web comics.
For which it never seems he has enough time anyway.
-
Rugged Rock Studio
- CodeUnit Collections
- Funakoshi Karate International South Africa
- Rugged Rock Studio: The Portfolio of Craig Lotter
- The Codeunit of Craig
- The House of C
- The Rugged Rock of Craig
Tag Archives: duplicate
SQL: Finding Duplicate Rows based on Multiple Columns
Locating duplicate rows based on multiple column values with SQL turns out to be a fairly simple exercise. Continue reading
Posted in Technology & Code, Tutorials Tagged duplicate, duplicate rows, multi column, multiple columns, select, sql View Comments
SQL: Finding all Duplicate Records in a Table
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 that we are focusing on a particular column and deeming that should that particular key appear more than once in the table then we have a duplicate scenario. Continue reading
Posted in Tutorials Tagged duplicate, duplicate records, duplicate values, query, records, sql View Comments
MySQL: Duplicate a Table
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 will in fact create a copy of your existing table, taking all the data from your source table and dumping it into your newly created clone table. Continue reading
Posted in Technology & Code, Tutorials Tagged backup, create table, duplicate, mysql, sql, table View Comments
