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