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
What can I do with mysql?
What are mysql functions?
What is pragma autonomous_transaction?
How do I stop a query in mysql workbench?
How to set the time zone for MySQL to particular country time?
How do I change mysql password?
How can you change the name of any existing table by using the sql statement?
What is difference between mysql and mysqli?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
What is a tinyint?
Why do we use views instead of tables?
Is mysql case-sensitive?
Explain csv tables.
How can you take the backup and restore a mysql database using php?
What happens if you no create privilege in a database?