MySQL Query Problem

MRAB python at mrabarnett.plus.com
Fri Sep 17 12:03:14 EDT 2010


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, late_fee, 
late_fee_paid) values (%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))

[snip code]



More information about the Python-list mailing list