Answer Posted / anubhav tiwari
1.DELETE COMMANDS: ONLY DELETE DATA FROM TABLE NOT THE
STRUCTURE OF THE TABLE.DATA CAN BE CALL BACK USING ROLL
BACK.
2.DROP COMMANDS DLETE TABLE AND STRUCTURE BOTH FROM THE
DATABASE ie.DATA CANT BE ROLL BACK OVER HERE.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
Is mysql a server or database?
What is a table schema?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
What does mysql_query return?
Explain Access Control Lists.
How do I start mysql manually?
How to see table's field formats or description of table .
What is the difference between b-tree and hash indexes?
Can mysql handle big data?
How do I drop a database in mysql?
Why use stored procedures in mysql?
How you can create a trigger in mysql?
Where is the myisam table stored?
What is max connections in mysql?