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 vote172 views1 answer
Least spark sql
SQL
0 vote157 views1 answer
Drop all triggers oracle
SQL
3 votes147 views2 answers
Current year sql
SQL
0 vote176 views1 answer
Sql last time database was accessed
SQL
2 votes174 views1 answer
Oracle kill session by sql_id
SQL
0 vote171 views2 answers
Mysql dump structure only
SQL
4 votes155 views4 answers
Oracle tablespace tables list
SQL
2 votes184 views1 answer
Oracle log files
SQL
1 vote144 views1 answer
Launch sql script from docker in mysql
SQL
-1 vote158 views1 answer
Concat two columns in sql server
SQL