postgresInsert into a table
INSERT INTO person (first_name, last_name, email, gender, date_of_birth, country_of_birth)
VALUES ('Janaya', 'Lindenstrauss', '[email protected]', 'Female', '2021/05/27', 'ID');ctrl + cINSERT INTOinserts data into table person | personname of the table to insert data to |
(first_name,columns list to insert data into | VALUESlist of values to insert into columns (the same order as columns) |
More of Postgres
- How to use aliases
- How to use AND / OR operators
- How to select unique (distinct) values from column
- Create Table
- How to group resulting set by specific column values
- Order By
- How to filter resulting set after grouping is done
- Drop database
- How to select column which value is between two values
- Where
See more codes...