database recode delete command help

Discussion in 'Databases' started by indika250, Jan 13, 2012.

  1. #1
    im developing php and data base driven system for track courier service. i created other pages corectly. but no idea how to create delete selected recodes at once.need serious help to do want delete all the data in selected recode and wan to know how to select recode to delete.need help asap
    Thanks
     
    indika250, Jan 13, 2012 IP
  2. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #2
    If it is a record you mean when you say recode then use : DELETE FROM table_name WHERE record_id=<id>
     
    iama_gamer, Jan 26, 2012 IP
  3. RamMurti

    RamMurti Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    if you want to delete multiple records then you can use DELETE FROM table_name WHERE record_id in {all the selected ids)
     
    RamMurti, Feb 2, 2012 IP
  4. ezprint2008

    ezprint2008 Well-Known Member

    Messages:
    611
    Likes Received:
    15
    Best Answers:
    2
    Trophy Points:
    140
    Digital Goods:
    1
    #4
    Don't forget or if you don't already know you can Append, overwrite etc, rather than delete, unless you need the files and tables literally removed.
     
    ezprint2008, Feb 5, 2012 IP