SQL Commands are mainly classified into four types, which are DDL command, DML command, TCL command and DCL command. SQL is mainly divided into four sub language Data Definition Language(DDL) Data Manipulation Language(DML) Transaction Control Language(TCL) Data Control Language(DCL) Only f...

1. INNER JOIN 2. LEFT JOIN 3. RIGHT JOIN 4. OUTER JOIN 5. LEFT JOIN EXCLUDING INNER JOIN 5. RIGHT JOIN EXCLUDING INNER JOIN 7. OUTER JOIN EXCLUDING INNER JOIN Inner JOIN This is the simplest, most understood Join and is the most common. This query will return all of the records in the left ...

Data Definition Language (DDL) statement are used to define the database structure or schema. some example: (1) Create - To create object in database. (2) Alter - To alter the structure of the database. (3) Drop - Delete object the structure from the database. (4) Truncate - Remove all the rec...

<?php include db_config.php ?> <table width="100%" border="1"> <tr> <td><strong><font color="#000000">Application No.</font></strong></td> <td><strong><font color=&quo...

vcampus থেকে কি আমি certificate অর্জন করতে পারব? ...

Defination:

SQL is a standard language for accessing and manipulating databases. What is SQL? SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL is an ANSI (American Nat...

How to insert data into two relational tables? Let’s we have created two table in sms databases as follows:

Table 1: product _category with sample records

Id name 1 Mobile 2 computer

Table 2: product with sample...

আমি ডাটাবেজ থেকে কুয়েরি করে লাষ্ট ৫ টা পোষ্ট ইন্টারফেইস এ শো করাতে পারছি না। যদি কেউ এই কমান্ড টা আমাকে দেন তাহলে উপকৃত হব।...

What is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases SQL is an ANSI (American National Standards Institute) standard What Can SQL do? SQL can execute queries against a database SQL can retrieve data from a database SQL can i...