SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Clearing table.

  1. #1
    Your daddy. WALoeIII's Avatar
    Join Date
    Apr 2001
    Location
    USA
    Posts
    526
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Clearing table.

    I have a table that I would like to clear every week, I am just going to have a simple form with a submit button, that will let me clear the table, I just don't have any idea how to do the sql syntax, should I delete the table, and then re-create it? because I don't think I can insert blanks, since that would just create more rows, what syntax?

  2. #2
    SitePoint Member
    Join Date
    Jun 2001
    Location
    PA
    Posts
    9
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This should help:

    http://www.mysql.com/documentation/m...ce.html#DELETE

    DELETE * FROM table
    Adam W.
    Web Developer / Columnist
    http://www.uscho.com

  3. #3
    Your daddy. WALoeIII's Avatar
    Join Date
    Apr 2001
    Location
    USA
    Posts
    526
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    wow, I am retarted, I knew that, LOL! Thanks for reminder!


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
  •