Databases Tutorials & Guides

MySQL 12 Mar 2020

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 → 24,181 hits

MySQL 14 Dec 2016

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 → 20,480 hits

MySQL 13 Jun 2016

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 → 10,823 hits

MySQL 13 Jun 2016

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 → 22,070 hits

MySQL 22 Oct 2014

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 → 15,137 hits

Transact-SQL 20 Aug 2014

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 → 26,218 hits

MySQL 28 Jul 2014

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 → 191,498 hits

Transact-SQL 04 Jun 2014

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 → 61,887 hits

Transact-SQL 27 Mar 2014

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 → 56,632 hits