I'm trying to change the definition of a field and getting 1025 errors
when I try. Here's a simplified reproducible test case, on MySQL 5.
CREATE TABLE `Users` (
`UserId` int(11) NOT NULL,
PRIMARY KEY (`UserId`)
) ENGINE=InnoDB;
CREATE TABLE `Actions` (
`ActionId` int(11) NOT NULL
Hi Wayne,
On Feb 19, 2008 4:52 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm trying to change the definition of a field and getting 1025 errors
when I try. Here's a simplified reproducible test case, on MySQL 5.
CREATE TABLE `Users` (
`UserId` int(11) NOT NULL,
PRIMARY KEY (`UserId`)
)
Hm, ok. Then one more followup question, if dropping the FKs is
necessary, is there any way to figure out how long such an operation
will take? SHOW PROCESSLIST usually just has copying to tmp table
or some such, does SHOW INNODB STATUS or any other commands give
insight into how long it will