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 vote256 views1 answer
Get the First and Last Word from a String or Sentence
SQL
1 vote273 views1 answer
How to start with sql
SQL
0 vote246 views2 answers
Avg() sql
SQL
0 vote258 views1 answer
MySQL import data from large CSV file
SQL
0 vote282 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote265 views1 answer
Mysql error 1251
SQL
0 vote263 views1 answer
Sql getdate minus 1 day without time
SQL
1 vote255 views1 answer
Mysql select update same table
SQL
2 votes283 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote252 views1 answer
Query on date sqlite flutter
SQL