Using Triggers in MySQL
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.
MySQL: Many To Many Relationships Part Two
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.
MySQL: Many To Many Relationships
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.
MySQL: What Are Sub Queries & How Are They Used?
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.
Store Multiple Values In A Single Row MySQL – Revisited
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.
Using PHP & MySQLi With A MySQL Database Part 2
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.
Using MySQL To Search For Any Word In Any Order
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.
Delete Row Animation WordPress Style In jQuery + Adding MySQL Delete
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 [...]
Creating A On-The-Fly Sortable Table With PHP, MySQL & jQuery
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, [...]
Storing Multiple Items In One MySQL Field – Alternate Method
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 [...]
Loading ...
