Sql query to find records not containing value – code example
akamit
SQL provides NOT IN (…) keyword to fetch records where column does not contain some values. In this article we will see few examples of different use cases. First, let’s…
Browsing Tag
mysql
6 posts
How to sum multiple columns in SQL? – Code Example
In this article, I will show you the ways to sum multiple columns in SQL. We will discuss how to prevent NULL columns from polluting the output. Code Examples 1.…
db_password db_user db_host db_port db_name – Code Example
In this article we will discuss about wordpress configuration to connect website with database like mysql. We will check out db_user, db_host, db_port, db_name and db_password fields. WordPress has a…
MSVCR120.dll is missing, mysqld.exe error WampServer – Code Example
WampServer throws error, mysqld.exe can’t start because MSVCR120.dll is missing if it is not able to find Microsoft Visual C++ Redistributable (MSVCR). The issue is that it requires all the…
fatal error: uncaught error: call to undefined function mysql_connect()
Php throws error fatal error: uncaught error: call to undefined function mysql_connect() when you use mysql_connect() function. This is because mysql_connect() is deprecated and no longer used. Instead, use mysqli_connect()…
MySql Timestamp – Right way to store datetime in tables
I struggled with the issue of storing date and time in database for a long time. Due to different time zones in the world, it is very hard to get…