affected (0.00 sec)
mysql>
mysql>
mysql> insert into Leads(LeadNo) values (1);
Query OK, 1 row affected (0.00 sec)
mysql> insert into Leads(LeadNo) values (2);
Query OK, 1 row affected (0.00 sec)
mysql> insert into Leads(LeadNo) values (3);
Query OK, 1 row affected (0.00 sec
Hi all.
I just tried adding a foreign key constraint, and crashed MySQL ( 4.0.18 ).
I tried it again and crashed it again :(
The SQL I'm using is:
---
alter table Leads
add foreign key fk_LeadNo ( LeadNo ) references Prospects ( LeadNo );
---
The tables involved:
`Prospects` (
`LeadNo` mediumint(8
