Skip to content

David Costello

dmcostello.com

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

MySQL

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: Retrieve all tables in a SQL Server database

24th August 2018 @davidcostello42

MySQL has a really useful command called SHOW TABLES. It lists you all the tables available in the connected database. Unfortunately Microsoft SQL Server doesn’t have such a useful shorthand […]

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

Programmatically storing your Database for Source Control

18th June 201817th September 2018 @davidcostello42

Databases are often a critical part of most applications today. But how do you go about storing them for Source Control purposes? There are a number of approaches – the […]

 Programming  Bash, Batch Scripts, Command Line, GIT, MySQL, Oracle, Poweshell, Programming, Shell, Source Control, SQL, SQL Server, SQLite, SVN  Leave a comment

Code Scraps: Hide system MySQL databases from phpMyAdmin listings

20th September 201720th September 2017 @davidcostello42

Here’s a quick code scrap to hide the system MySQL and phpMyAdmin databases from being listed within the web application itself. Open your phpMyAdmin’s config.ini.php file and locate the end […]

 Code Scraps  MySQL, PHP, phpMyAdmin, Programming  Leave a comment

Forgotten your MySQL root password? No problem!

6th May 201715th September 2017 @davidcostello42

I recently forgot the root password to a MySQL instance on one of my machines. Follow this quick and easy guide for whenever this happens to you. Stop MySQL sudo […]

 Programming, Security  Command Line, MySQL, Programming, Security, 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