Posted by Simon Stienen on 11/15/67 11:23

On 2005-08-08 13-41-45 Hartmut Jaeger
<hartmut.jaeger@jaeger-edv-service.de> wrote:
> But DROP deletes the complete table and the index and all structures. I
> want to keep an empty table with all the structures, which I can fill
> with data again.

TRUNCATE <tablename>;

HTH,
Simon
--
Simon Stienen <http://slashlife.org/>
"What you do in this world is a matter of no consequence,
The question is, what can you make people believe that you have done."
/Sherlock Holmes in A Study in Scarlet by Sir Arthur Conan Doyle/

• Next in forum: Re: Sending PHP Emails
• Prev in forum: Re: mysql_connect works; DB::connect doesn't
• Thread view: Re: How to delete a MySQL database table without system()

[Reply to this message]