[Tutor] python & mysql question
Danny Yoo
dyoo at hkn.eecs.berkeley.edu
Thu Sep 7 16:05:34 CEST 2006
>> I have to store and retrieve text files from a database table and the
>> size of each file is about 500k. Can someone give me an idea on how to
>> do this?
>>
>> Thanks,
>> Patricia
> http://dustman.net/andy/python/python-and-mysql
> Provides some background for the MySQLdb module. This should get you
> started. The next reference provides more background, but may not be
> needed.
And just as a heads up: you'll probably need to configure your database
tables to use TEXT or LONGTEXT columns, since 500k texts are definitely
larger than the 255-char limit imposed by varchars.
More information about the Tutor
mailing list