Sql truncate table using this statement you can remove all data of rows or column ( complete data ) not table. in this there is no where clause but where clause is available in delete statement.

In mysql, delete and truncate both are used for deleting data from table.deletedelete comes under dml (datamanipulation language). delete canbe used to delete a particular rowby using where clause.it ...

At work we use a homemade ticket system coded in ASP to track users' problems here at work. Basically, every user has a shortcut on their desktop that opens up a form that allows them to type a ...