[Tutor] Handling hundreds of thousands of inserts with MySQLdb

[Kent Johnson]

Gonzillaaa wrote:
> another issue is that some of the fields values are empty and I  
> get the following :
>
> ./xbow_MySQL_insert.py:49: Warning: Out of range value adjusted for  
> column 'sample' at row 64
>    cursor.executemany("INSERT INTO arup_04 \
>
> is there a way to "silence" python so it doesn't output the errors?
Rather than silence the warnings I would fix the data. You could process 
each row in your returnTuple() function. Alternately you could perhaps 
change your database table to allow the data.

Kent