What are the differences between drop a table and truncate
a table?
Answer Posted / ramavtar rajput
drop--> means table is delete ,not roll back,
truncate-->
| Is This Answer Correct ? | 18 Yes | 11 No |
Post New Answer View All Answers
How MySQL Optimizes DISTINCT?
How will show all records containing the name "sonia" and the phone number '9876543210'
What tools available for managing mysql server?
change column name and make a unique column so we get no dupes.
Which datatype is used for email in mysql?
What is max connections in mysql?
What is the use of i-am-a-dummy flag in mysql?
Write a query to count the number of rows of a table in mysql.
How to include numeric values in sql statements?
What are the functions of commit and rollback statements?
What is a trigger? How you can create a trigger in mysql?
What is pdo :: fetch_assoc?
What is the maximum size of table in mysql?
Write a query to find duplicate rows in table?
How to calculate the difference between two time values?