
Dangers of Adding fields to Database Tables
There are certain dangers if you don't plan carefully before adding fields to your database. Though, it seems obvious but its not as simple as you might think. If you don't plan properly you may miss …
There are certain dangers if you don't plan carefully before adding fields to your database. Though, it seems obvious but its not as simple as you might think. If you don't plan properly you may miss …
Recent versions of MySQL have implemented support for foreign keys through the InnoDB table engine. Following is an explaination of how it works. Referential integrity is an important concept in da…
Many hackers constantly try to breach your secure data and steal your secure information away. People generally think that they can't secure their data actively but this isn't true. If you're using My…
Relational Database Design is one of the most powerful ways to ensure data integrity and a great way to kick-off any project. Very often the first thing developers do when starting a new project, or…
Every website has ‘em. Forms. Places for users to enter data into your website. Whether it be a search box, a “Contact Us” form, or variables in the website address, at some point in the flow of your …
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form),…