Implementing Pagination using PHP and MySQL – Introduction In order to understand how pagination works in php, we need to revisit how the LIMIT clause works in MYSQL queries. If you recall, we can fetch a predetermined number of records from a database table by using a query with a LIMIT clause as follows: SELECT […]
Learn MySQL Fundamentals
Using Foreign Key constraints in MySQL – Part 2
Hello and welcome to Part 2 of the article ‘Using Foreign Key constraints in MySQL. In this article we will look at what happens when we add, delete or update records in all the tables. So far we have three tables: employees, departments and projects. As you may recall from part 1 of this article, […]
Using Foreign Key constraints in MySQL – Part 1
In this article we will look at how to use foreign key constraints in MySQL. We’ll be creating a Database with tables which are related to one another through the use of Foreign Keys. A Foreign key is nothing but a copy of a Primary Key in another table, think of it like a ‘link’ […]