I used a VARCHAR(10) data type for a duration column. Now, I am getting this error :
Unable to add/edit/delete row in table ‘Schedule’. → One or more SQL errors has been encountered: One or more SQL errors has been encountered:
The insert/update operation attempted to write data that was too large for a column in your MySQL table.
Original error message from the database: Data too long for column ‘TotalWorkDuration’ at row 1
I am not seeing what the issue here is when duration is only 8 characters such as “00:10:45”?
What is the recommended datatype in SQL for a duration column?