Answer Posted / senthil d
Delete Command - Options to Delete particular record using
where clause and to delete all records. Table structure
remains. But it slower in performance as we compared with
truncate command
Drop Command - Drops the entire table from data base
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is difference between schema and table?
What are the two types of queries?
What is the difference between char and varchar in mysql?
What is mysqli procedural?
What is the current version of mysql?
all the queries used in sql
What is “i_am_a_dump” flag in mysql?
What is 'mysqlshow'?
Is mysqli faster than mysql?
Is there a free mysql?
What is blob and text in mysql?
What is schema in mysql?
How to filter data from a mysql database table with php?
Why myisam is faster than innodb?
How many mysql connections can handle?