<div dir="ltr"><div><div><div><div>Hi All,<br><br></div> Is there any way in DBIx to delete all rows from resultset in a single query, it looks like delete and delete_all will delete the resultset row by row.<br><br></div>
my $rs = $schema->resultset('User')->search({GroupId => 712});<br>$rs->delete_all;<br><br></div>If there are 100 Users in User table then the above statement will delete in 100 query instead is there a way to delete in single query.<br>
<br></div>DELETE FROM User WHERE GroupId = 712;<br><div><div><div><div><br clear="all"><div><div><div><div><div dir="ltr"><div><br></div>Best Regards, <br>Sheeju Alex<br>
<div style="display:inline"></div></div></div>
</div></div></div></div></div></div></div></div>