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:
SHOW CREATE TABLE BOARD_SERIAL_NUMBER;
mysql SHOW CREATE TABLE
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
SNIP---
You need to end each INSERT INTO statement with a semicolon (;), not a
comma (,). Also pressing enter after each one will allow you to easier
diagnose any problems that might come up.
-
I have
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 MODULE
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:
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