[PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread Naga Sean
How to delete all the data in database, without delete the table. Looks like I can't delete all the data with single click in PHPmyAdmin mySQL -naga _ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List

Re: [PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread Russ Michell
Using PhpMyAdmin click the 'empty' hyperlink. This will empty all the data from the table but not delete the table. HTH :) Russ #---# "Believe nothing - consider everything"

Re: [PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread olinux
you can, choose the database on the left hand side and you will se all of your tables in that db on the right with the option to EMPTY olinux - Original Message - From: "Naga Sean" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 02, 2001 12:25 AM Subject: [PHP-DB]

Re: [PHP-DB] Delete all Data and keep the Table

2001-04-02 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Naga Sean) wrote: How to delete all the data in database, without delete the table. Do you want to delete every *table* in the *database*, or delete every *row* in the *table*? Assuming the latter, "delete from database_name". -- CC -- PHP