Sql

Search

postgresql delete multiple rows

If you have to select the id:

 DELETE FROM table WHERE id IN (SELECT id FROM somewhere_else)

If you already know them (and they are not in the thousands):

 DELETE FROM table WHERE id IN (?,?,?,?,?,?,?,?)

Comment

PREVIOUS	NEXT

Code Example
Sql :: flask sqlalchemy update row
Sql :: oracle free up space in tablespace
Sql :: datetime postgres typeorm
Sql :: run mysql command from bash
Sql :: create table in sql server
Sql :: host 127.0 0.1 is not allowed to connect to this mysql server
Sql :: mysql multiple order by
Sql :: osx stop mysql service
Sql :: sql server create constraint
Sql :: orcale index size
Sql :: get cpu details sql
Sql :: mysql order by
Sql :: display all node label neo4j
Sql :: lack create session privilege oracle
Sql :: postgresql float 2 decimal places
Sql :: dba_dependencies
Sql :: change column data type sql
Sql :: mysql select date from datetime
Sql :: sql server list database
Sql :: mysql case
Sql :: uppercase sql
Sql :: alter table query sql server change column
Sql :: second highest salary in sql
Sql :: sql column name
Sql :: insert into without column names
Sql :: delete from inner join sql
Sql :: SQLITE_BUSY: database is locked
Sql :: mysql if else
Sql :: mysql create table index
Sql :: SQL Remove Primary Key Constraint - MySQL

Search

SQL

postgresql delete multiple rows

ADD CONTENT