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 vote342 views2 answers
Mysql regexp match word
SQL
0 vote336 views1 answer
Check psql validity function
SQL
3 votes325 views2 answers
Oracle sql truncate table
SQL
0 vote434 views1 answer
Calculer pourcentage mysql
SQL
0 vote366 views1 answer
Psql initialization
SQL
0 vote368 views1 answer
Postgresql find missing id
SQL
0 vote365 views1 answer
Sql query contains multiple ids
SQL
0 vote327 views1 answer
Sql max min
SQL
0 vote383 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote342 views1 answer
Many rows to 1 string mysql
SQL