I've been doing a project recently, there are a lot of test data in the database, and then deleted with the delete * statement, but found that since the growth of the column (generally the primary key) cardinality and did not return to zero, after access to data, found a solution is to use the TRUNCATE function, you can delete all the data in the table, And you can return the cardinality from the growth column to zero. The SQL statement is as follows:
View Sourceprint?1truncate TABLE TableName--the data to be manipulated in TableName
Note that the above SQL will not take effect until all the data in the table is deleted. I just need to delete the data, if you are not able to empty the data, that is not yet found a way, so sometimes feel, is not too practical.
Note : Please pay attention to the triple programming Tutorials section for more wonderful articles .