MySQL

Objective To use the comment in SQL Comments are used to prevent line of a statement from the execution, Comments can make your application easier for you to read and maintain, Comments are used to

Overview of SQL OUTER JOIN SQL OUTER JOIN is used to preserve all of the records that have values in either the left or right table, In the SQL OUTER JOIN all the content of

Overview of SQL INSERT INTO SELECT statement SQL insert into select statement is used to insert data from one table to another, where data is the resulting set of records using SQL Select statement, using

How to delete table in SQL SQL DROP TABLE command is used to remove a table structure and its all records with indexes, triggers, constraints and also all the permission on that table, to remove

How to add column to table in SQL In SQL, to add column(s) to the existing table SQL ALTER TABLE ADD statement is used, there is no statement like SQL ADD COLUMN to add the

What is Data type in SQL? SQL Data types are attribute associated with a piece of data that tells a computer system how to interpret its value, A data type is an attribute that specifies

Overview of DATEADD SQL Function DATEADD  is a SQL date function that is used for manipulating DateTime datatype values, DATEADD function is used to add  or subtract the specific numerical value to a specified datepart

Overview of SQL Not Equal SQL Not Equal is a comparison operator used to compare two not null operand values or an expression, if the left operand value is not equal to the right operand

Overview of SQL If Statement SQL If Statement is a conditional statement used to execution flow of control, SQL If statement allows us to perform different actions based on conditions defined within the statement, if