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

4 votes220 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
2 votes225 views1 answer
Sql count having
SQL
0 vote233 views1 answer
Android sqlite add column if not exists
SQL
3 votes228 views2 answers
How to start mysql in terminal
SQL
0 vote228 views1 answer
Mysql add to value
SQL
10 votes188 views1 answer
Oracle view dependencies
SQL
1 vote233 views1 answer
Oracle datafile max size 32gb
SQL
0 vote231 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
2 votes234 views1 answer
Change primary key sql
SQL
5 votes229 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL