Re: Another MySQL Problem

[MRAB]

Victor Subervi wrote:

Hi;

mysql> truncate tem126072414516;
Query OK, 0 rows affected (0.00 sec)

Then I run a script:

  if whatDo == 'insert':
    try:

sql = 'insert into %s (ProdID, Quantity) values ("%s", "%s");' % (tmpTable, prodid, quantity)

      print sql
      cursor.execute(sql)

that runs this (printed out) sql insert statement:

insert into tem126072832767 (ProdID, Quantity) values ("2", "2");

But then this...

mysql> select * from tem12607282453 t join products p on t.ID=p.ID;
Empty set (0.00 sec)

mysql> insert into tem126072829782 (ProdID, Quantity) values ("2", "2");
ERROR 1062 (23000): Duplicate entry '2' for key 2

I have to manually truncate the table to manually insert it, and then it works. But programmatically, it doesn't insert...but it apparently inserts something, or it wouldn't throw the duplicate entry error. Where is the problem?

1. The table names look different.

2. Did you commit the changes?
--
http://mail.python.org/mailman/listinfo/python-list