Answer Posted / reddi prasad
THE MAIN DIFFERENCE BETWEEN DELETE AND DROP:
DELETE: ONCE WE DELETE ANY DATA FROM THE DATABASE WE CAN
EASILY RETURN BACK THE DATA BY USING ROLLBACK.
DROP: ONCE WE DELETE ANY DATA FROM THE DATABASE WE CAN'T EA
RETURN BACK THE DATA AND WE CAN SEE THE STRUCTURE OF OBJECT
ONLY.
| Is This Answer Correct ? | 9 Yes | 15 No |
Post New Answer View All Answers
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
Which storage engine is best in mysql?
How to use count function in mysql?
What is new mysqli?
Can we write procedure in mysql?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
Do I need to pay for mysql?
How do I find mysql location?
How to show all tables with 'mysql'?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
How do you rename a table?
What is dirty read and phantom read?
What is mysql architecture?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.