How to delete all table's data

Hijacking threads will not get you the quality answers that you seek. You will get more and better answers by starting your own thread.

 

You can delete all data of a table with the use of following command
SQL> delete * from table_name

 

Use truncate commend to delete all table contents from table.

 

select 'delete from ' + o.name + ';'
from sysobjects o,
sysusers u
where o.type = 'U'
and o.uid = u.uid
and upper(u.name) = 'xxx';

 

delete from yourtablename; will delete all data.

 

-------------------in Visual Basic : ---------------------

dim conn As ADODB.Connection
dim ConnString as string

ConnString="DRIVER={MySQL ODBC 3.51 Driver};SERVER=myServer;DATABASE=myDatabase;UID=admin;PWD=myPassword;PORT=3306;OPTION=3"

Set conn = New ADODB.Connection
conn.ConnectionString = ConnString
conn.CursorLocation = adUseClient
conn.Open

'--------------The table name is Perkiraan--------------------

conn.execute "Delete * from Perkiraan"

 

Though both DELETE and TRUNCATE can be used to accomplish the task of emptying a database table, You may want to consider performance and undo space and other factors. Remember that Truncate is generally faster than Delete and also does not use as much Undo space as a Delete statement. If there are any associated triggers on the deleted table, then you should be aware that row-level delete triggers do not fire for a Truncate operation, while they do fire for a Delete operation.

 

Sara Reece: Please share with me about trigger

 

HI ! delete data from SQL table :

DELETE FROM Persons WHERE LastName='Tjessem' AND FirstName='Jakob'

Above syntax use when you want delete first and last name from table.

DELETE FROM students it will delete whole table.

Delete data from PHP :

mysql_query("DELETE FROM Persons WHERE LastName='Griffin'");

 

Vanessa ....do you know about trigger in mySQL ?

 

Hi sywids ! i know about the trigger. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. MySQL triggers are activated by SQL statements only.

• Triggers are not activated by changes in INFORMATION_SCHEMA tables, because these tables are actually views.
  
• Triggers are not activated by updates made using the NDB API.