PHP-MySQL

It is quite normal in SQL databases to reference and ID number rather than a name. this way if the name changes that change can be reflected without the need of updating information in all…

In this tutorial we take a quick run through MySQL installing it on openSUSE but the platform really could be anything. Using openSUSE we can use zypper to implement the install: zypper -n in mysql mysql-administration…

We have seen the default behaviour of MySQL where the server tries to help us by adjusting data that does not fit into a column until it is is acceptable. For example if trying to…

When creating tables within MySQL databases we have to consider the data type that we use for each column. In this section we will look at the use of Integer values and the use of…

The Default Account When MySQL is installed the default user is created, root. This account is the server administrator with full rights to the server. All user accounts to MySQL are stored in the system…