DELETE FROM users WHERE id in [1,2.3]; would delete the three users with one of those ids (or none at all, if the ids didn’t exist.)
DELETE FROM users WHERE last_name=“Smith”; would delete all users with the last_name of Smith. > On Jan 22, 2018, at 9:06 AM, Stephen J. Orth via 4D_Tech > <[email protected]> wrote: > > SQL newbie here... > > What is the correct syntax for deleting a number rows in a SQL database? Is > it possible to use a 4D array which contains the values used by the WHERE > clause? > > Or, do we have to delete each row individually? > > Thanks! > > > Steve > > ********************************************* > Stephen J. Orth > The Aquila Group, Inc. Office: (608) 834-9213 > P.O. Box 690 Mobile: (608) 347-6447 > Sun Prairie, WI 53590 > > E-Mail: [email protected] > ********************************************* > > ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
