pymysql.err.DataError: (1265, u"Data truncated for column

  File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\cursors.py", line 193, in executemany self._get_db().encoding) File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\cursors.py", line 230, in _do_execute_many rows += self.execute(sql + postfix) File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\cursors.py", line 166, in execute result = self._query(query) File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\connections.py", line 856, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\connections.py", line 1057, in _read_query_result result.read() File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\connections.py", line 1340, in read first_packet = self.connection._read_packet() File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\connections.py", line 1014, in _read_packet packet.check_error() File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\connections.py", line 393, in check_error err.raise_mysql_exception(self._data) File "E:\ProgramData\Anaconda2\lib\site-packages\pymysql\err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.DataError: (1265, u"Data truncated for column 'test_val' at row 5")