Re: [PHP-DB] Delete all Data and keep the Table
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" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331 www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Delete all Data and keep the Table
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] Delete all Data and keep the Table 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 (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Delete all Data and keep the Table
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 Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]