* vishnu mahendra > is there any simple ways to interface python with mysql
<URL: http://sourceforge.net/projects/mysql-python > > if yes tell me the details how do we do it in > windows and linux You will find instructions on the sourceforge site. A small demo, low level API: >>> import _mysql >>> c = _mysql.connect() >>> c.query('select * from test.test') >>> res = c.store_result() >>> res.describe() (('id', 3, 1, 11, 11, 0, 0), ('name', 253, 4, 30, 30, 0, 0), ('email', 253, 13, 80, 80, 0, 1)) >>> res.fetch_row() (('1', 'test', '[EMAIL PROTECTED]'),) >>> res.fetch_row() (('2', 'foo', '[EMAIL PROTECTED]'),) >>> There is also a higher level API conforming to the Python Database API specification included in the distribution. <URL: http://www.python.org/topics/database/DatabaseAPI-2.0.html > -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
