Jump to content

Erase everything in a table

- - - - -
Started by Paradine, Nov 08 2006 12:22 PM

This topic has been archived. This means that you cannot reply to this topic.
5 replies to this topic

#1
Paradine
Posted 08 November 2006 - 12:22 PM

Paradine

    Learning Programmer

  • Members
  • PipPipPip
  • 48 posts
I can't remember how to erase everything in a table. Anyone know real quick?

#2
WingedPanther
Posted 09 November 2006 - 09:39 AM

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
DELETE FROM table_name
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
Guest_Jordan_*
Posted 09 November 2006 - 10:06 AM

Guest_Jordan_*
  • Guests
Or you could use

TRUNCATE [TABLE] tbl_name

as well

#4
Paradine
Posted 12 November 2006 - 11:32 AM

Paradine

    Learning Programmer

  • Members
  • PipPipPip
  • 48 posts
That works, thank you!

How do I delete all of the tables from a database now?

#5
Jimbo
Posted 12 November 2006 - 05:03 PM

Jimbo

    Programmer

  • Members
  • PipPipPipPip
  • 121 posts
Not 100% but I think its 'DROP tablename'

#6
Lop
Posted 20 November 2006 - 08:05 AM

Lop

    Speaks fluent binary

  • Members
  • PipPipPipPipPipPipPipPip
  • 1,172 posts

Jimbo said:

Not 100% but I think its 'DROP tablename'

That is correct.
Back to Database & Database Programming




  1. CODECALL Programming Forum
  2. → Web Development Forum
  3. → Database & Database Programming
IPB skins by Skinbox