Jack Wallen explains how to add data into a MySQL table from the command line.

Those changes cannot be undone for a non-transactional table, so MySQL continues to execute the statement to avoid a partial update. It converts each invalid value to the closest legal value, as ...