Question

By default, MySQL does not clip out of range numeric values to the nearest fit value.

(a) True

(b) False

This question was addressed to me during an online interview.

This key question is from Writing Clients That Include SSL Support in chapter MySQL Programs Using C of MySQL

Answer 1

Correct answer is (b) False

For explanation: For the numeric or TIME columns, the values that are outside the legal range are clipped to the nearest endpoint of the range. The resulting value is stored. This is the method to handle defaults for numerics.