Search In
In MySQL, the IN operator is used to allow us specify multiple values in a WHERE clause.
IN Operator Syntax
SELECT column_name
FROM table_name
WHERE column_name IN (value1,value2,...);
We have a table "employee" as below:
employee
id f
Dual table:
DUAL table is a dummy table which
contains one row and one column and
by default it is present in
database.It contains a single
VARCHAR2(1) column known as DUMMY
with a value "X".
It can be accessed by all users but
the owner of DUAL
In MySQL, we can select rows where a column is null by using IS NULL operator.
We have a table "employee" as below:
employee
id first_name salary country
......................................................
Hi Reader's,
Welcome to FindNerd, today we are going to discuss what is utilization of md5() function.
md5() function is used to providing security for protecting your password.MD5 stands for Message-Digest Algorithm. Suppose you have a sim
It is not possible to have two db queries in model hook of ember js router. You can either create two router files- one for fetching the new records from database and the another one for fetching record.
That is not a good approach to create two ro
Introduction of LINQ:
Abbreviated for Language-Integrated Query (LINQ). It was introduced in Visual Studio 2008 and .NET Framework version 3.5. The main concept behind it was to fill the gap between world of objects and the world of data. LINQ makes
Hello Readers,
I came across a solution while working on mongodb and would like to share with you all in case you face any such problem while working on mongodb.
If you are coming across the error like the following:
Connection error: { [MongoErr
Simple code to fetch selected data from database table in excelsheet in cakephp:
Step 1: To achieve this we will use csvHelper class. Now make a file named as CsvHelper.php in your app/View/Helper directory, then add the following code written below
Caching with Data Source Controls:
Why do we need caching..?
In a Website majority of the pages are dynamic that provide dynamic content, customized
for the user requesting the page. Dynamic pages also help provide dynamic content fetched
from
Concurrency is mainly a problem that can occur when we have a resource that is held by different persons.
If multiple process or multiple users wants to access the same resource then which one to allow and which one to deny needs a mechanism
