What are the differences between drop a table and truncate
a table?
- 10 Answers
- 22654 Views
- I also Faced
- E-Mail Answers
Answer Posted / raabhu
Drop a Table : Delete over all table is called drop...
Truncate a table : Delete only the field names of table is
called truncate...
| Is This Answer Correct ? | 6 Yes | 12 No |
Post New Answer View All Answers
How can you handle the –secure-file-priv in mysql?
What are queries used for?
How do I run mysql from command line?
How many columns can be used for creating Index?
Can we write pl sql mysql?
How do I select a database in mysql?
What does mysql flush privileges do?
Write a query to create a database and a table?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
What does schema mean?
What are the advantages of mysql?
How can you find out the version of the installed mysql?
What is innodb_buffer_pool_size?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
How do I download a mysql community server?
