-
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.
CodeUnit Post Archive
Tag Archives: duplicate
How to Duplicate a Table in FlameRobin
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 very lightweight nature! Nevertheless, there are times I must use it, and use it I … Continue reading
Posted in Tutorials
Tagged copy, database, dbms, duplicate, firebird, flamerobin, Open Source, table
1 Comment
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
7 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
Leave a comment
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
Leave a comment
