Search In
In SQL, LIKE clause is basically used to search the homogeneous data using wildcard from a database. The LIKE operator is used to find out the particular string from a table's field into database.
Some wildcard examples are given as b
<-- Chapter 4: SQL Distinct
Chapter 5
SQL Where
SQL Where : SQL Where clause extract or filters those records which matches the specified condition. Syntax for Where clause is used below
SELECT *
FROM tablename
WHERE condition
Here "condit
Sql Injection
Application security is always a challange for the application developer. As some of anonymous users who try to break your application for his fun. Sometimes loopholes in your application can be more dangerous for you and your applicat
In MySQL, COUNT() function used to return the number of rows that matches with a specified criteria.
Syntax:
COUNT(column_name)
When we use COUNT(column_name) function in select query it returns the number of rows for the specified column:
SELECT
Hi Team,
Today I will explain Lazy Loading and Eager Loading.
Firstly we will explore Eager Loading.
Eager Loading is the process of loading the related data. We will use Include keyword to load the related data.
Let us take an example of entity
Following is the XML which we want to create:
SELECT magazineId
, magazineName
, coverPage
, publishDate
, expiryDate
, isActive
,(
SELECT (
SELECT (
SELEC
Hi Readers,
We can download video file from Youtube if we know youtube URL of the video. First you need to add attached files (HCYoutubeParser) into your project. Now you need to call following function into your code:
let video = HCYoutubeParser
The SELECT TOP clause is used to return specific number of records with thousands of records. It is used to select top N number of records from a table. We can use number or percent to select record.
TOP clause is not supported by all the databases.
For deleting user information in cake php by clicking on delete button we have to first pass user id in URL by using below code in our view.
<?php echo $this->Html->link('Delete',array('action'=>'del'.$user['User']['id']));
And we hav
Cybersecurity
Many companies domestic or global follow several sets of rules, policies, standards, and practices to securely transfer data. This is an evolving arena. Protection of integrated systems and network interfaces is the prime object
