Insert into sql

Dev Shed Forums Sponsor:

January 28th, 2013, 03:11 AM

MynE

Contributing User

Join Date: Nov 2012

Posts: 35

Time spent in forums: 6 h 32 m 59 sec
Reputation Power: 1

Insert into sql

Hi guys i'm having problems with sql. Supposed that I have 3 arguments like this: a = 'abc', b = 'bca', c ='cba' and when I used the sql command

Code:

con.execute('INSERT INTO Facebook (Description, ByPersonName, Date) VALUES (%s, %s, %s)', a, b, c)

it said TypeError: execute() takes exactly 3 arguments (5 given) I tried with executemany and changed %s to ?, it's still keep saying like this.
Can somebody help me find out the solution of this problem pleasee >o<

Thank you

January 28th, 2013, 03:41 AM

b49P23TIvg

Contributing User

Join Date: Aug 2011

Posts: 3,358

Time spent in forums: 1 Month 2 Weeks 3 Days 9 h 33 m 51 sec
Reputation Power: 383

one or both of these should workd:

Code:

con.execute('INSERT INTO Facebook (Description, ByPersonName, Date) VALUES (%s, %s, %s)', (a, b, c) )

con.execute('INSERT INTO Facebook (Description, ByPersonName, Date) VALUES (%s, %s, %s)'%(a, b, c) )

__________________
[code]Code tags[/code] are essential for python code!

January 28th, 2013, 03:54 AM

MynE

Contributing User

Join Date: Nov 2012

Posts: 35

Time spent in forums: 6 h 32 m 59 sec
Reputation Power: 1

Oh I see thank you so much for your help

January 28th, 2013, 02:40 PM

MynE

Contributing User

Join Date: Nov 2012

Posts: 35

Time spent in forums: 6 h 32 m 59 sec
Reputation Power: 1

Hi, may I ask you more. Supposed I have a data like this :

kk = ('a', 'b', 'c')
jj = ('myne', 'myne', 'myne')
dd = ('2013-01-28', '2013-01-28', '2013-01-28')

When I tried to use executemany

Code:

con.executemany("INSERT INTO Facebook (Description, ByPersonName, Date) VALUES (%s, %s, %s)", (kk , jj, dd))

the results I get is

Line 1: Description = a, ByPersonName = b, Date = c
Line 2: Description = myne, ByPersonName = myne,Date = myne
Line 3: Description = 2013-01-28, ByPersonName = 2013-01-28,Date = 2013-01-28

The data doesn't get into column properly, if you know this problem please tell me, Thank you!!

January 28th, 2013, 03:26 PM

b49P23TIvg

Contributing User

Join Date: Aug 2011

Posts: 3,358

Time spent in forums: 1 Month 2 Weeks 3 Days 9 h 33 m 51 sec
Reputation Power: 383

Again, without actually knowing what I'm doing, you need transposition. zip transposes.

Code:

con.executemany("INSERT INTO Facebook (Description, ByPersonName, Date) VALUES (%s, %s, %s)", zip(kk , jj, dd))

Developer Shed Advertisers and Affiliates