delete from table-name will delete all the rows from a table. Adding a where clause to the end of it will delete rows which meet the where criteria. You might want to purchase a good SQL book for this command and others. -----Original Message----- From: Cahyo S. Aji <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, January 17, 2001 7:57 AM Subject: [PHP-DB] multiple delete > >What is the query to delete multiple rows from a table or multiple tables? >Is there any simple queries to do it? > > >_Ajik_ > > >-- >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] > >