Posts tagged 'mysql'
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.
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.
[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"
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.
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.
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.
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.