todd hewett wrote:
>>>mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
>>>mysql> VALUES(36534);
>>>
>>>ERROR 1216: Cannot add a child row: a foreign key constraint fails
>
>
>>Can you please post the output of:
>
>
>> mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
>> mysql> VALUES(36534);
>>
>> ERROR 1216: Cannot add a child row: a foreign key constraint fails
>Can you please post the output of:
>SHOW CREATE TABLE BOARD_SERIAL_NUMBER;
>> mysql> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT
SNIP---
You need to end each INSERT INTO statement with a semicolon (;), not a
comma (,). Also pressing after each one will allow you to easier
diagnose any problems that might come up.
-
I have run th
Howdy Folks I hope this is not too much information.
I have
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
I have multiple tables.
All are innoD Tables.
All AI on a Primary key integer
All Columns are varchar 255 that are not keys.
Table VCS_PO_NUMBER
Has
Thanks Gleb,
That was educational.
Is there a way to log connections in such a way that is easy to tell how
many connections were happening at one time?
Thanks,
Todd
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 12:26 AM
To: mysql@l
Howdy Folks,
I have an app that cannot get information from mysql database for some reason.
Here is an query which application is trying to run but after some timeout
(something about 2-3 minutes):
11 Jul 2005 03:32:18,485 DEBUG [Thread-20] (PressReleaseDAO.java:328) -
sqlselect prd.press_release
