MySQL

Overview of SQL Exists SQL Exists is a logical operator used with SQL WHERE clause as the conjunction of the subquery to check whether the result of a subquery (correlated nested query) contains any record

Overview of SQL LIMIT SQL limit is a clause used with SQL select Statement and is used to set a maximum limit on the number of records returned by SQL select statement, the value specified

Overview of SQL Contains The SQL contains is the SQL predicate Boolean function used with WHERE clause in the SQL Select statement to perform full-text search operations like search for a word, the prefix of

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