Useful bit of SQL to update many records in SugarCRM

Thu 27 March 2014

When GUIDs are you're only option...Cheat!

UPDATE clowns SET deleted=1 WHERE id IN
(SELECT id FROM (
  SELECT id FROM clowns WHERE deleted = 0 ORDER BY id ASC LIMIT 0, 800)
tmp );

Category: SugarCRM Tagged: sugar sugarcrm php

Comments