Answer Posted / kasirajan
delete command deletes the table temporarily from the database. we can get it back using the keyword ROLLBACK.
but the drop keyword deletes the table permanently from the database,we cant able to get it back...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is constraints? Also explain the different types of constraints?
What is the difference between char and varchar in mysql?
Can a table have multiple primary keys?
Where does mysql store data?
What, if a table has one column defined as TIMESTAMP?
what is mysql optimization in brief?
Can mongodb replace mysql?
What is difference between mysql and mariadb?
Will mysql remain free?
What are the features of mysql?
How do you name a table?
How to convert character strings to dates?
What is difference between inner vs self vs cross?
What is mysql database extension?
How to use 'mysql' to run sql statements?