"NULL" can be defined as, "A missing unknown value" that is not equal to any values such as 0,1 or empty.
we can stop,start or restart mysql by simply passing parameters to mysqld process. mysqld is the main program that does the most of the work in mysql.
when you pass a query result to mysql_fetch_array, it should contain some data otherwise it will returns a warning like "mysql_fetch_array() expects parameter 1 to be resource (or mysqli_result), boolean given"
So how many characters is enough to store an ip address in a mysql table? As the length of IP address varies from IPv4 to IPv6, To define the size of a column that ip address is going occupy, we must know maximum length of the ip address in both versions so that we can assign the maximum length to mysql column.
In MySql, Your update query will not run as expected when concatenating a column which has null value. Query doesn't show any issues but the value will not be updated.
When retrieving data from mysql tables sometimes we might have got this error: mysql_fetch_array() expects parameter 1 to be resource. This warning tells us, we are passing an empty result variable for processing.
I just installed 32 bit version of xampp 1.8.2 that included php 5.4, mysql 5.0.1 and apache 2.4.9. All three packed inside bitnami webdevelopment package, so the installation is simple and nice. But when i started mysql, it failed to start.