Insert or ignore postgres

INSERT INTO customers (NAME, email)
VALUES('Microsoft','hotline@microsoft.com') 
ON CONFLICT ON CONSTRAINT customers_name_key 
DO NOTHING;
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Insert or ignore postgres

INSERT INTO customers (name, email)
VALUES('Microsoft','hotline@microsoft.com') 
ON CONFLICT (name) 
DO NOTHING;
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Insert or ignore postgres

INSERT INTO 
    customers (name, email)
VALUES 
    ('IBM', 'contact@ibm.com'),
    ('Microsoft', 'contact@microsoft.com'),
    ('Intel', 'contact@intel.com');
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote144 views2 answers
How to install mssql on mac
SQL
0 vote132 views1 answer
Mysql procedure between two tables
SQL
0 vote132 views1 answer
Select multiple row from primary key sql
SQL
0 vote120 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
2 votes120 views3 answers
Postgres remove foreign key constraint
SQL
4 votes143 views1 answer
T-sql get duplicate rows
SQL
1 vote133 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote119 views1 answer
Search In the Database using Text
SQL
7 votes128 views2 answers
Phpmyadmin change password
SQL
0 vote132 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL