Delete every row 1

[macubergeek]

I'm trying to figure out the sql syntax to delete every row from a specified table. I don't want to drop the table just clean out every row...

I've tried:
DELETE * FROM TABLE_NAME;

DELETE * FROM TABLE_NAME WHERE id NOT NULL;

no luck.
Can someone give me a shove in the right direction?

 

[lgarner]

delete from table_name

 

[TonyGroves]

Another option would be "TRUNCATE tablename". The effect is the same as DELETE, but for big tables it's much faster.

 

[macubergeek]

lgarner and TonyGroves, thanks! Some how I was stuck in the SELECT syntax format. DELETE from <tablename> worked fine.