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
Can mysql handle big data?
Is mariadb better than mysql?
How do stored procedures work?
How do I know if mysql is running on windows?
What is mysql community server?
How do I restore a database in mysql workbench?
Can you tell how to find the number of rows in a resultset using php?
What, if a table has one column defined as TIMESTAMP?
How can we find out which auto increment was assigned on Last insert?
What is the latest mysql?
How to create a test table in your mysql server?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
What is the use of i-am-a-dummy flag in mysql?
What is a left join mysql?
Is mysql workbench a dbms?