Question

what will be the result of TRUNCATE(425.668,-1)? Explain.​

Answer 1

Explanation:

You might choose to truncate a table instead of dropping the table and recreating it. Truncating a table can be faster and does not affect any of the table's indexes, triggers, and dependencies. It is also a fast way to clear out the records from a table if you don't need to worry about rolling back.