Search In
TRUNCATE:
Truncate command will remove all the rows from a table, there will be no WHERE clause in TRUNCATE command and there will be no data in the table after we run the truncate command.
TRUNCATE i
When we don't define any data for a column then the column holds the NULL value. In MySQL, NULL values are used to represent data that is missing.
NULL Values
If you have created a table with optional columns then you can insert and update records
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
......................................................
Are you looking to start a career in Cryptocurrency and Blockchain? Do you want to know where to look for employment opportunities? If you answered yes to all or any of the questions above, then sit tight and follow me as I'll be doing justice to
Hi Reader's,
Welcome to FindNerd, today we are going to discuss how to use LIKE operator in MySQL?
Basically, LIKE operator is used for searching for a specified pattern in a column. So in other words we can say that the LIKE operator is u
In SQL while writing stored procedures sometimes you need variables for calculations and manipulations.
Variable we can use of two type
1 Local
2 Global
ALTER proc [dbo].[sp_CalculateRemainingLeaves]
(
@Employ
Sometime we need to have dropdown for states related to countries just as we have for United States by default, for that we need to add states of particular country. To add custom states we need to modify the tables of magento. There are two tables i
What is WebApi ?
The term API stands for Application Programming Interface.
ASP.NET Web API is a framework which uses HTTP services and that is consumed by various clients. In web Api we can return data on the client requests. As, if we are reque
NSUserDefaults is used to save the data for as long as the app is installed. When you write data to NSUserDefaults, it automatically gets loaded when your app runs so that you can read it back again.
In NSUserDefaults we use key to save the data and
If we forget administrator password in Drupal then it is very easy to recover it using Email or Drush. But situation get tougher when we don't have Drush and email notification enabled.
In this way only database update query is the best way but you m
