Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Delete All Rows a Table
How To Delete All Rows a Table? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: FYIcenter.com
If you want to delete all rows from a table, you have two options:
The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good example of TRUNCATE statement:
SELECT COUNT(*) FROM fyi_links; COUNT(*) ---------- 3 TRUNCATE TABLE fyi_links; Table truncated. SELECT COUNT(*) FROM fyi_links; COUNT(*) ---------- 0
2007-04-21, 5018👍, 0💬
Popular Posts:
Where Is the Submitted Form Data Stored? - PHP Script Tips - Processing Web Forms When a user submit...
How do I debug thread ? This window is only seen when the program is running in debug mode. In windo...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...
How To Control Horizontal Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By...
How To Divide Query Output into Groups? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY You...