How can i delete more than one record?

Results 1 to 2 of 2

Thread: How can i delete more than one record?

  1. #1
    Schmid Michael Guest

    Default How can i delete more than one record?

    I know the code for deleting one record <BR>"Delete from table where ID=1" but how can I delete more than one record?<BR><BR>Michael Schmid

  2. #2
    Daniel Ohnemus Guest

    Default RE: How can i delete more than one record?

    Use the following syntax:<BR>DELETE * FROM [DATABASE] WHERE [QUALIFY WHAT ITEMS YOU WANT TO DELETE]<BR><BR>Such as (for example, in a dictionary database called WordDB where the words are stored in a "Word" field)<BR>DELETE * FROM WordDB WHERE Word like "B_"<BR>This deletes all one and two letter B words. Get it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •