What is the difference between TRUNCATE and DELETE in MySQL

  • The DELETE command is used to delete data from a table. It only deletes the rows of data from the table while, truncate is very dangerous command and should be used carefully because it deletes every row permanently from a table.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

What are the common MySQL functions

Differentiate CHAR_LENGTH and LENGTH

What is the difference between CHAR and VARCHAR

Differentiate between FLOAT and DOUBLE? 

What are the different tables present in MySQL?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
What is the difference between TRUNCATE and DELETE in MySQL
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges