Answer / velmurugan

Drop - will Delete the table date as well as the table
structure.
Truncate - Will Delete the table data only. The table
structure will remains.

Answer / meena bisht

Drop: drop means it will drop the table including structure
and free the memory from hard disk.

Truncate: Truncate will truncate the data. The structure
will remain there and also will free the memory.

Answer / soumik

1.DELETE table will result into deletion of data from the
table without affecting the table structure. But since
delete statement is a DML(Data Manipulation Language)
statement, it directly dosnt reflect the database. In other
words, the deleted data will be stored in a separate
tablespace called UNDO tablespace(which takes up memory)
that can be retrieved by using a ROLLBACK statement.

2. DROP table results into loss of data and structure both
which cannot be retrieved. Drop statement is DDL(Data
Definition Language) which is AUTO-COMMIT.

3. TRUNCATE table will clear the data from the table only
without affecting the table structure. Data cannot be
retrieved after executing this statement as well, since it
an AUTO-COMMIT statement. Truncate is also a DDL statement.

Answer / ramavtar rajput

drop--> means table is delete ,not roll back,

truncate-->

Answer / ......v......

TRUNCATE <table_name>;
This will only Remove table data and not structure of table

DROP <table_name>;
This will Remove table data and structure both

In both the cases data can be Rollbacked in SQL Server 2000
or 2005.....,But NOT POSSIBLE in other.........!

Answer / guru

1.DELETE:
- delete space allocated by mysql server and the structure of table remains same.
- used by either 'WHERE' clause or without it in mysql.
- data can be roll backed
2.TRUNCATE:
- Remove rows from mysql table but the structure of table remains same.
- The data cannot be roll backed
- can be used by only without 'WHERE' clause in mysql.
3. DROP:
- Remove whole table from mysql database.
- The data cannot be roll backed

For more details visit: http://www.phponwebsites.com/2014/01/mysql-delete-truncate-drop-difference.html

Answer / shital

Delete - delete all the data from table but structure still remains as it is.
Truncate - delete all data from table but structure remains and memory still allocated for table.
Drop - delete all data as well as structure and also free the memory.

Answer / raabhu

Drop a Table : Delete over all table is called drop...

Truncate a table : Delete only the field names of table is
called truncate...

Answer / karthik

truncate means it will truncate the data, we can retrieve
it whenever we want using commit
drop - it delete the full structure as well as the data.
cant make a recovery.

Answer / sudha

Truncate Table - Truncate table is the combination of Drop
and Create. It [Truncate]can drop and recreate the table.
Delete - Delete will deletes all the data in the table and
structure of the table.

Is mysql a database?

0 Answers  

What are CSV tables?

1 Answers  

What is data in mysql?

0 Answers  

What are the drivers in MySQL?

1 Answers  

Is mysql good for large database?

0 Answers  

What is mysql routine?

0 Answers  

What is mysqli procedural?

0 Answers  

How to get help information from the server?

0 Answers  

In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?

0 Answers  

What are the advantages of myisam over innodb?

0 Answers  

What is mysql in linux?

0 Answers  

What is definer in mysql trigger?

0 Answers