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 data in mysql?
Explain the different types of constraints?
How large can a mysql table be?
How to analyze tables with 'mysqlcheck'?
Why mysql is so popular?
What are the security alerts while using mysql?
How do I start mysql from command line?
How do I find the database name in mysql?
How to convert character strings to numeric values?
Is number a datatype in mysql?
How many columns can a table have?
What is append query?
Is postgresql better than mysql?
What does blob mean in mysql?
How do I truncate all tables in mysql?