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 are the functions of mysql?
Why is it called mysql?
Can mysql and mariadb coexist?
What is mysql architecture?
What are programming functions?
How we get sum of column.
What is “i_am_a_dump” flag in mysql?
How can you handle the –secure-file-priv in mysql?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
why not null is not allowed at table level
How is oracle different from mysql?
What is maximum table size in mysql?
What does tinyint mean?
How do I automate a backup in mysql?
How would you enter characters as hex numbers?