Relational Deletes in MySql and Foreign Keys

Managing relational tables in a database is a topic that all developer will eventually bump into. There are quite a few ways of managing relational data, and the best solution sometimes can be hard to find. As a developer you have to look at the scope of the application, the types of tools you have…

Replacing a Range of Fields in MySQL

Replace a range of values in a single MySQL column with the following query: Update [Table_Name] Set [Column_Name] =  replace([Column_Name], ‘[String to Replace]’,'[New String]’) Where id Between [someNumber] and [anotherNumber]