0 comments / July 10, 2016

Select null values in mysql

"NULL" can be defined as, "A missing unknown value" that is not equal to any values such as 0,1 or empty.


0 comments / August 12, 2015

How to stop,start and restart mysql in command line

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.


0 comments / July 03, 2015

[SOLVED] Warning:mysql_fetch_array expects parameter 1 to be resource

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"


0 comments / July 02, 2015

What is maximum length of ip address?

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.


0 comments / November 06, 2014

MySql concat null values

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.


0 comments / June 19, 2014

mysql_fetch_array() expects parameter 1 to be resource

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.


4 comments / June 18, 2014

SOLVED: InnoDB Error: space header page consists of zero bytes: xampp

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.