JSON vs. SQL: What’s the Difference?

This is done by using commands. SQL commands are the instructions used to communicate with the database to perform specific tasks. The following are the common types of commands: 

• Update: This command is used to modify the existing data in a database table. Using this, you can change the values based on specified conditions. 

UPDATE table_name 
SET column1 = value1, column2 = value2 
WHERE condition; 

• Insert: To insert any new data into a database table, developers can specify the values to be inserted for each column. 

INSERT INTO table_name (column1, column2) 
VALUES (value1, value2); 

• Select: This retrieves data from a database by specifying the columns and tables from which you want to retrieve data. Developers can also apply conditions to store and customize the result set according to their requirements. 

SELECT column1, column2 
FROM table_name; 

• Create: This is used to create a new database table or view. Developers can define the structure, columns, data types, and constraints of the object accordingly. 

CREATE TABLE table_name ( 
column1 datatype, 
column2 datatype, 
… 
); 

• Truncate: It deletes all data from a table while keeping its structure unchanged.  

TRUNCATE TABLE table_name; 

• Group By: It is used to group rows based on one or more columns. Mostly, this command is used along with aggregate functions to carry out calculations on groups of data. 

SELECT column1, COUNT(column2) 
FROM table_name 
GROUP BY column1; 

• WHERE: It is used to filter data based on specific conditions. Developers can specify criteria to selectively retrieve rows that meet the given conditions. 

SELECT column1, column2 
FROM table_name 
WHERE condition; 

• DROP: It permanently deletes a database object. 

DROP TABLE table_name; 

These are the common commands, also known as SQL queries, to manipulate and manage data in a database.