Scripts, systems & field notes.

MySQL 12 Mar 2020 24068

MySQL: Count occurrences of words in a column

This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL.

Read note →

MySQL 04 Oct 2018 20376

MySQL Transactions in PHP

Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"...

Read note →

MySQL 04 Oct 2018 10708

Trim values along with the tab

A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.

Read note →

MySQL 04 Oct 2018 21965

Convert foreign characters to English alphabet

A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent.

Read note →

MySQL 22 Oct 2014 15024

MySQL Updating a database table from another table

A quick article on how to populate a database column from another table using a string comparison.

Read note →

Transact-SQL 20 Aug 2014 26073

T-SQL functions to convert Strings to Tables

These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How?

Read note →

MySQL 28 Jul 2014 191377

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connect

This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears whe...

Read note →

Transact-SQL 04 Jun 2014 61777

Convert to Proper Case in T-SQL

So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments.

Read note →

Transact-SQL 27 Mar 2014 56505

T-SQL: Parse an XML value

This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.

Read note →