deleting multiple records

Results 1 to 2 of 2

Thread: deleting multiple records

  1. #1
    Join Date
    Dec 1969

    Default deleting multiple records

    I want to delete mutple records a the same time but they all have no attributes the same.<BR><BR>I tried <BR>DELETE * FROM MyDB WHERE id = 13,22,33<BR>But this doesn&#039t work

  2. #2
    Eddie Campbell Guest

    Default RE: deleting multiple records

    I assume that you want to delete multiple records from the same table in your database, and not from multiple tables. If so, this should work.<BR><BR>DELETE * FROM MyTable WHERE ( = 13) OR ( = 22) OR ( = 33)

Posting Permissions

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