SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2002
    Posts
    168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    simple multiple row delete

    Hi folks

    Perhaps my brain has finally packed it in, and that probably is the case, but do you know why this simple multiple row delete query does not work?

    DELETE FROM myTable WHERE id=1 AND id=2

    It doesn't return an error in a PHP script but it does not do anything either. The same thing happens when running it in phpMyAdmin.

    HUH? Am I finally losing it?

  2. #2
    SitePoint Guru
    Join Date
    Jan 2001
    Location
    Alkmaar, Netherlands
    Posts
    710
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    replace AND with OR if you want to delete both records.

  3. #3
    SitePoint Zealot
    Join Date
    Aug 2002
    Posts
    168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thx sylow


Bookmarks

Posting Permissions

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