Duplicate Entry, But Table Empty!

--0016364275f7663f63047a9f4090
Content-Type: text/plain; charset=ISO-8859-1

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 | Type | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+------- ---------+
| ID | int(5) unsigned | NO | PRI | NULL | auto_increment |
| ProdID | int(5) unsigned | YES | UNI | NULL | |
| Quantity | int(3) unsigned | YES | | NULL | |
+----------+-----------------+------+-----+---------+------- ---------+
3 rows in set (0.00 sec)

Please advise.
TIA,
Victor

--0016364275f7663f63047a9f4090--

Re: Duplicate Entry, But Table Empty!

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=gcdmg-mysql-2@m.gmane.org

Re: Duplicate Entry, But Table Empty!

--00235447101441e50a047a9fb495
Content-Type: text/plain; charset=ISO-8859-1

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");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '*tem126072414516* (ProdID, Quantity) values ("2", "2")' at line 1

Please advise.
V

--00235447101441e50a047a9fb495--

Re: Duplicate Entry, But Table Empty!

--0016e646926aa157cb047aada9f9
Content-Type: text/plain; charset=ISO-8859-1

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> select * from *tem126072385457*;
> >>
> >
> >
> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near '*tem126072414516* (ProdID, Quantity) values ("2", "2")' at line 1
>
> Please advise.
> V
>

--0016e646926aa157cb047aada9f9--

Re: Duplicate Entry, But Table Empty!

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/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org