Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Delete All Rows a Table
How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE 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:
mysql> SELECT COUNT(*) FROM fyi_links; +----------+ | COUNT(*) | +----------+ | 5 | +----------+ 1 row in set (0.08 sec) mysql> TRUNCATE TABLE fyi_links; Query OK, 0 rows affected (0.02 sec) mysql> SELECT COUNT(*) FROM fyi_links; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec)
2007-05-11, 6421👍, 0💬
Popular Posts:
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
What is the version information in XML? “version” tag shows which version of XML is used.
An application needs to load a library before it starts to run, how to code? One option is to use a ...
What will be printed as the result of the operation below: #define swap(a,b) a=a+b;b=a-b;a=a-b; void...
.NET INTERVIEW QUESTIONS - How can you avoid deadlock in threading? A good and careful planning can ...