Sql delete from with relation

# your select statement acctually works (and I don't know wich is your statement...).
# You must replace only
SELECT ...
# with
DELETE [table name or alias]
# and leave everything else the same.

# e.g:
DELETE cu FROM CustomUser cu 
left join RoleMapping on cu.id = RoleMapping.principalId 
WHERE RoleMapping.roleId = 1;

Source: stackoverflow.com

Similar codes

0 vote192 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote301 views1 answer
Mysql grant access to one database
SQL
9 votes197 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote218 views1 answer
Sql count total by foreign key
SQL
10 votes206 views2 answers
Mysql drop database if exists
SQL
49 votes285 views6 answers
Get duplicate records in sql
SQL
14 votes196 views2 answers
Oracle add column with default value
SQL
5 votes255 views1 answer
Purge undo tablespace usage
SQL
0 vote218 views1 answer
Regex any word except sql
SQL
2 votes281 views1 answer
Mariadb json select
SQL