Home > MySQL
Permalink to Using Triggers in MySQL

Using Triggers in MySQL

by on 09.12.2011 | no comments

A tricky subject I came across recently was how to use Triggers in a MySQL database. I always stayed away from them as I thought they were difficult to work with, but it turns out they are much easier than I expected.

Permalink to MySQL: Many To Many Relationships Part Two

MySQL: Many To Many Relationships Part Two

by on 02.18.2011 | no comments

Following on from the last tutorial, we are going to take a look at how to assemble some slightly more complex queries to filter the results from our many to many relationships.

Permalink to MySQL: Many To Many Relationships

MySQL: Many To Many Relationships

by on 02.08.2011 | 1 comment

A fairly difficult subject to approach in MySQL is Many to Many relationships. The queries can be complicated and the data sets huge, but as it seems to be covered by tutorials very little I thought I’d have a shot a writing a tutorial about it.

Permalink to MySQL: What Are Sub Queries & How Are They Used?

MySQL: What Are Sub Queries & How Are They Used?

by on 01.21.2011 | 6 comments

I have had a few questions recently asking what sub queries are and how they are used. While there are a number of articles out there on the subject they don’t explain it in a detailed manner as I would like. So here is my take on them.

Permalink to Store Multiple Values In A Single Row MySQL – Revisited

Store Multiple Values In A Single Row MySQL – Revisited

by on 01.07.2011 | 31 comments

I originally wrote a post about 2 year ago explaining how to store multiple values in a single MySQL row. Now I have more experience with PHP/MySQL I have decided to revisit this topic to clear up any confusion about the method that should be used.

Permalink to Using PHP & MySQLi With A MySQL Database Part 2

Using PHP & MySQLi With A MySQL Database Part 2

by on 04.29.2010 | 3 comments

Continuing on from the last post which covered the basics of connecting to a database using MySQLi, we are going to look at inserting, updating & deleting data. Finally we are going to look at some of the miscellaneous features of MySQLi.

Permalink to Using MySQL To Search For Any Word In Any Order

Using MySQL To Search For Any Word In Any Order

by on 03.11.2010 | 3 comments

A limitation with searches using MySQL is that when using LIKE to find the words queried it will only find them if they are together in the same order they were written. Here is how to change that so the words are found in any order.

Permalink to Delete Row Animation WordPress Style In jQuery + Adding MySQL Delete

Delete Row Animation WordPress Style In jQuery + Adding MySQL Delete

by on 02.19.2009 | 18 comments

Ok, so yesterday I did a tutorial about making a animation similar to that which WordPress uses when you delete posts etc. You know the [...]

Permalink to Creating A On-The-Fly Sortable Table With PHP, MySQL & jQuery

Creating A On-The-Fly Sortable Table With PHP, MySQL & jQuery

by on 12.19.2008 | 38 comments

So a few people have contacted me asking me how to create a table that sorts without contacting the MySQL server again. Well it’s simple, [...]

Permalink to Storing Multiple Items In One MySQL Field – Alternate Method

Storing Multiple Items In One MySQL Field – Alternate Method

by on 11.02.2008 | 2 comments

A little while ago I posted about storing more than one piece of information in a MySQL table field. This can come in handy for [...]

Page 1 of 212