MySQL dymanic query in Python
RAHUL RAJ
omrahulrajcse at gmail.com
Thu May 30 08:22:52 EDT 2013
On Wednesday, May 29, 2013 3:32:51 PM UTC+5:30, Fábio Santos wrote:
> On 29 May 2013 10:13, "RAHUL RAJ" <omrahu... at gmail.com> wrote:
>
> >
>
> > Can anyone tell me the proper way in which I can execute dynamic MySQL queries in Python?
>
> >
>
> > I want to do dynamic queries for both CREATE and INSERT statement.
>
> >
>
> > Here is my attempted code:
>
> >
>
> >
>
> > sql="create table %s (%%s, %%s, %%s ... )" % (tablename,''.join(fields)+' '.join(types))
>
> > cur.execute(sql)
>
> >
>
> >
>
> > where 'field' is the fieldnames stored in a list and 'types' are the fieldtypes stored in a list.
>
> You need to join the fields and the field types. Use zip().
>
> Then join with commas.
>
> fields_and_types = ['%s %s' % (field, type) for field, type in zip(fields, types)]
>
> what_goes_between_the_parens = ', '.join(fields_and_types)
>
> sql = 'create table %s (%s)' % (tablename, what_goes_between_the_parens)
>
> See where that gets you.
Fantastic! It worked, Thanks :)
More information about the Python-list
mailing list