Mysql
SQL OUTER JOIN Explained [Practical examples]
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 both tables …
SQL INSERT INTO SELECT with Practical Examples
This article of SQL INSERT INTO SELECT, the article begins with the overview of SQL INSERT INTO SELECT with syntax, use of each syntax argument and clause, the …
Delete table in SQL / DROP TABLE in SQL [Practical Examples]
In this article of delete table in SQL, we have covered the delete table command DROP TABLE used to delete a table in SQL with syntax and explanation of each …
How to alter table and add column SQL [Practical Examples]
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 column or to modify …
SQL Data Types Explained [Practical Examples]
an overview of SQL data types, also define a list of SQL data types, we have explained each category of data types and described each category data type with …