Skip to content

David Costello

dmcostello.com

  • Home
  • About
  • Articles
    • Internet
    • Programming
    • Uncategorised
  • Projects
  • Resources
    • Downloads
    • Links
  • Contact

Data

Code Scraps: Finding duplicate records in MySQL

22nd January 2019 @davidcostello42

This is a quick code scrap to illustrate how to identify duplicate field values in record sets in MySQL. The code may also work for other SQL languages, but do […]

 Code Scraps, Programming  Data, MySQL, Programming, SQL  Leave a comment

Code Scraps; Validating undefined and null in Javascript

1st August 20171st August 2017 @davidcostello42

I’m always forgetting how to to this in Javascript – here’s a couple of ways of validating if an object is undefined or null, and the good points about using […]

 Code Scraps, Programming  Data, Javascript, JSON, Programming, Validation  Leave a comment

Code Scraps: Get a list of all content in a directory on Windows

25th July 201712th September 2017 @davidcostello42

I recently posted a code scrap for getting all content of a directory in Linux. Here is the same code scrap but for Windows. C:\TestDir\> dir /b /s > C:\temp\files.txt […]

 Computing, Programming  Batch Scripts, Command Line, Data, Data Formatting, Poweshell, Windows  1 Comment

Code Scraps: Random unique colour generation

18th November 201615th September 2017 @davidcostello42

I have worked on a number of social projects over the years which have involved message boards or social posting features by users.  On some websites like Microsoft’s message boards or StackOverflow […]

 Code Scraps, Programming  Data, Data Formatting, PHP, Programming, Random  Leave a comment

Code Scraps: Word list tidying

8th October 201615th September 2017 @davidcostello42

I have recently been messing around with dictionary lists for a little personal project. My goal has to been to make an anagram/word finder, where you provide up to 9 letters […]

 Code Scraps  Data, Data Formatting, Programming  Leave a comment

Bulk generate SQL, JSON objects or code markup using Excel / Spreadsheet

15th August 201615th September 2017 @davidcostello42

Sometimes I have had a need to turn an un-formatted or unstructured data set into a database table or more recently into a set of JSON objects. The source data […]

 Programming  Data, Data Formatting, HTML, JSON, Programming, SQL  Leave a comment

Search

Archives

  • January 2021
  • October 2020
  • March 2019
  • January 2019
  • December 2018
  • October 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • March 2017
  • February 2017
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • June 2014
Proudly powered by WordPress | Theme: Moesia by aThemes