id | int(11) | | PRI | 0 | |
| fc_date | date| | PRI | -00-00 | |
+-+-+--+-+----+---+
2 rows in set (0.00 sec)
mysql>
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
Newsgrou
Can you mysqldump the table then rebuild the table from the dump file?
-Original Message-
From: Rich Schramm
To: 'Victor Pendleton'; [EMAIL PROTECTED]
Sent: 5/18/04 2:04 PM
Subject: RE: Alter table primary key and foreign keys
The error log shows nothing when the binary dies
ch Schramm '; '[EMAIL PROTECTED] '
Subject: RE: Alter table primary key and foreign keys
I would first see if an upgrade to a later version of InnoDB tables is
possible. What is being written to the error log? The ALTER TABLE
statement subtly creates a new table, with new contraint name
child table?
-Original Message-
From: Rich Schramm
To: [EMAIL PROTECTED]
Sent: 5/18/04 12:43 PM
Subject: Alter table primary key and foreign keys
I am using mysql 4.0.12 max-nt on Windows XP.
I have a master table with an int column as a primary key (bom_id) and a
second table that has a
I am using mysql 4.0.12 max-nt on Windows XP.
I have a master table with an int column as a primary key (bom_id) and a
second table that has a foreign key reference to the master column and
uses it as part of a composite key (bom_id, fc_date). Example:
**
bom_mstr
p
