Re: Duplicate Entry, But Table Empty!

2009-12-14 Thread Mattia Merzi
2009/12/13 Victor Subervi : [...] > Please advise. review your sql: you are inserting into tem126072414516 and selecting from tem126072385457 ( Asterisk in Pinter Tibor's mail means "bold" ) Greetings, Mattia Merzi. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Duplicate Entry, But Table Empty!

2009-12-14 Thread Johan De Meersman
Gods. What is this, a creche ? *plonk* On Sun, Dec 13, 2009 at 6:44 PM, Victor Subervi wrote: > On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote: > > > Victor Subervi wrote: > > > >> Hi; > >> > >> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", > "2"); > >> mysql> sele

Re: Duplicate Entry, But Table Empty!

2009-12-13 Thread Victor Subervi
On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote: > Victor Subervi wrote: > >> Hi; >> >> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2"); >> mysql> select * from *tem126072385457*; >> > > mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2"); ERRO

Re: Duplicate Entry, But Table Empty!

2009-12-13 Thread Pinter Tibor
Victor Subervi wrote: Hi; mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2"); mysql> select * from *tem126072385457*; t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Duplicate Entry, But Table Empty!

2009-12-13 Thread Victor Subervi
Hi; mysql> insert into tem126072414516 (ProdID, Quantity) values ("2", "2"); ERROR 1062 (23000): Duplicate entry '2' for key 2 mysql> select * from tem126072385457; Empty set (0.00 sec) mysql> describe tem126072385457; +--+-+--+-+-++ | Field