Difference between Drop, Truncate and Delete statements in MySQL
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
Drop - deletes the data as
Wed, 06/11/2008 - 03:28 — adminDrop - deletes the data as well as structure
Truncate - deletes only the data, and resets the auto increment column to 0
Delete - Deletes the selected/all rows from a table, it doest not reset auto increment., here we can delete set of records by specifying the condition in where clause
If Delete is used, the date
Fri, 04/15/2011 - 04:29 — webtrainingsIf Delete is used, the date can be rollback or commit depending on the requirements.
http://www.webtrainings.in