471,336 Members | 1,294 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,336 software developers and data experts.

sqlite tuples

I am fairly new to Python and am trying to get to grips with pysqlite2.
>From what I have read data is returned as a list of tuples when using
SELECT via connection.cursor. But I have not, despite frantic googling,
found how to INSERT a list of tuples into a sqlite table. If I convert
the tuple to a string and concatenate it to the 'INSERT INTO table etc.'
string then it works, but only if all the tuple values are strings and
then only if all the table fields are of type TEXT.

Is it possible to, and if so how can one, insert a list of tuples into a
sqlite table?

Regards, John
--
War is God's way of teaching Americans geography
Ambrose Bierce (1842 - 1914)
Jul 17 '07 #1
0 899

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by bolly | last post: by
12 posts views Thread by John Salerno | last post: by
4 posts views Thread by Jim Carlock | last post: by
8 posts views Thread by Gilles Ganault | last post: by
reply views Thread by Joe Goldthwaite | last post: by
4 posts views Thread by marc wyburn | last post: by
20 posts views Thread by timotoole | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.