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 filter column based on multiple values
- Order By
- Where
- Select columns from table
- How to select column which value is between two values
- How to filter resulting set after grouping is done
- How to select unique (distinct) values from column
- How to group resulting set by specific column values
- Drop table
- Create database
See more codes...