On 17/09/2010 15:59, Victor Subervi wrote:
I rebooted MySQL and it now works fine ;)
I recommend that you always list the column names explicitly to be on
the safe side:
cursor.execute('insert into Passengers (flights_id, customer_id,
name, sex , weight, price, round_trip, confirmation, l
I rebooted MySQL and it now works fine ;)
On Fri, Sep 17, 2010 at 9:26 AM, Victor Subervi wrote:
> Here's some more data:
>
> print 'insert into Passengers values (Null, %s, %s, %s, %s, %s, %s,
> %s, %s, "no", "n/a")' % (curr_flight, curr_customer, name, curr_sex,
> curr_weight, price, cu
Here's some more data:
print 'insert into Passengers values (Null, %s, %s, %s, %s, %s, %s,
%s, %s, "no", "n/a")' % (curr_flight, curr_customer, name, curr_sex,
curr_weight, price, curr_rt, curr_confirmation)
cursor.execute('insert into Passengers values (Null, %s, %s, %s, %s,
%s, %
Hi;
I have this code:
cursor.execute('insert into Passengers values (Null, %s, %s, %s, %s,
%s, %s, %s, %s, "no", "n/a")', (curr_flight, curr_customer, name, curr_sex,
curr_weight, price, curr_rt, curr_confirmation))
Now, when I print it out, add quotes where necessary and enter it in at a
