On Wednesday, May 29, 2013 3:32:51 PM UTC+5:30, Fábio Santos wrote:
> On 29 May 2013 10:13, "RAHUL RAJ" wrote:
>
> >
>
> > Can anyone tell me the proper way in which I can execute dynamic MySQL
> > queries in Python?
>
> >
>
> >
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)
I'm getting same output for both code parts, why not for th code parts in
question?
On Thursday, May 9, 2013 1:48:51 PM UTC+5:30, RAHUL RAJ wrote:
> Then what about this code part?
>
>
>
> [(x, y) for x in [1,2,3] for y in [3,1,4] if x != y]
>
>
>
Then what about this code part?
[(x, y) for x in [1,2,3] for y in [3,1,4] if x != y]
and the following code part:
for x in [1,2,3]:
for y in [3,1,4]:
if x != y:
combs.append((x, y))
On Thursday, May 9, 2013 12:24:24 PM UTC+5:30, Gary Herron wrote:
> On 05/08/2013 11:36 PM, RA
Checkout the following code:
sample2 = [x+y for x in range(1,10) for y in range(1,10) if x!=y]
output=[]
output=[x for x in sample2 if x not in output]
the output I get is
3 4 5 6 7 8 9 10 3 5 6 7 8 9 10 11 4 5 7 8 9 10 11 12 5 6 7 9 10 11 12 13 6 7 8
9 11 12 13 14 7 8 9 10 11 13 14 15 8 9 10