1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Query Question (Newbie)

Discussion in 'MySQL' started by William, Oct 19, 2005.

0
  1. #1
    Is there a query i can run in a mysql database to delete Db entires in a certain entry span. For exampel delet from enterynumber 56 to 77 and all entires in between?

    thanks in advance.
     
    William, Oct 19, 2005 IP
  2. tflight

    tflight Peon

    Messages:
    617
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Do you mean something like:

    delete from my_table where entrynumber >=56 and entrynumber <=77
     
    tflight, Oct 19, 2005 IP
  3. William

    William Well-Known Member

    Messages:
    1,310
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    140
    #3
    Yes. I mean something like that.

    Can it be done?
     
    William, Oct 19, 2005 IP
  4. king_cobra

    king_cobra Peon

    Messages:
    373
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #4
    thats what he had given u, the answer.

    DELETE FROM table WHERE criteria_filed >= 56 AND criteria_filed <= 77
    Code (markup):
     
    king_cobra, Oct 19, 2005 IP
  5. William

    William Well-Known Member

    Messages:
    1,310
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    140
    #5
    Ok. sorry.
    just seemed to easy.

    thank you, both of you.
     
    William, Oct 19, 2005 IP