Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between drop a table and truncate
a table?
- 10 Answers
- 25589 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
What is the difference between mysql_connect and mysqli_connect?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
What is current version of mysql?
Can we use mysql and mysqli together?
Is mysql an oracle product?
How can we optimize stored procedure?
What is mysql workbench used for?
can you tell what are the different set operations available in mysql? : Mysql dba
How to delete the repeated records from a table?
What is the datatype of image?
What is innodb_buffer_pool_size?
What is bigint in mysql?
What is mysql connection limit?
What is mysql vs sql?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
