Pada Tue, 27 Aug 2002 20:20:33 -0500
"Gerald R. Jensen" <[EMAIL PROTECTED]> menulis :
> Trevor ...
>
> Do you want to drop the tables, or simply delete the data in them and retain
> the table structure?
>
> To delete data ...
> USE databasename;
> DELETE * FROM tablename;
>
> To drop tables ...
> DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT |
> CASCADE]
... or .... you just do :
truncate table <tablename>;
--
Let's call it an accidental feature.
-- Larry Wall
MySQL 3.23.51 : up 67 days, Queries : 357.694 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
