Postgres - INSERT Statement | How to insert data in table in SQL смотреть онлайн

SQL INSERT statement is a SQL query. It is used to insert a single or a multiple records in a table.

There are two ways to insert data in a table:

By SQL insert into statement
By specifying column names
Without specifying column names
By SQL insert into select statement

1) Inserting data directly into a table
You can insert a row in the table by using SQL INSERT INTO command.

There are two ways to insert values in a table.

In the first method there is no need to specify the column name where the data will be inserted, you need only their values.

INSERT INTO table_name
VALUES (value1, value2, value3....);
The second method specifies both the column name and values which you want to insert.

INSERT INTO table_name (column1, column2, column3....)
VALUES (value1, value2, value3.....);
Let's take an example of table which has five records within it.

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)
VALUES (1, ABHIRAM, 22, ALLAHABAD);
INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)
VALUES (2, ALKA, 20, GHAZIABAD);
INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)
VALUES (3, DISHA, 21, VARANASI);
INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)
VALUES (4, ESHA, 21, DELHI);
INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)
VALUES (5, MANMEET, 23, JALANDHAR);


2) Inserting data through SELECT Statement
SQL INSERT INTO SELECT Syntax

INSERT INTO table_name
[(column1, column2, .... column)]
SELECT column1, column2, .... Column N
FROM table_name [WHERE condition];

#SQL,structured query language,introduction to sql,#RDBMS,#PGClient, Learn SQL,#postgres,#postgresql,#postgresql tutorial,#postgres tutorial,#what is postgresql,#what is postgres,#history of postgresql #postgressql,#postgresql tutorial for beginners,#postgresql course,postgres,postgresql,postgresql tutorial,postgres tutorial,what is postgresql,what is postgres,history of postgresql,postgressql,postgresql tutorial for beginners,postgresql course