Comment on Things that don’t work well with MySQL’s FOREIGN KEY implementationparentComments−zerocrates3yWhoa, I've never made a foreign key on a non-unique column, had no idea MySQL would allow that. I guess I've pretty much always done foreign keys pointing to primary keys, so they're definitely unique.−majora20073yDid you know you can also have a BLOB as a primary key for a table? I found that in an app I just took over the other day. Was shocked.
Comments
Whoa, I've never made a foreign key on a non-unique column, had no idea MySQL would allow that. I guess I've pretty much always done foreign keys pointing to primary keys, so they're definitely unique.
Did you know you can also have a BLOB as a primary key for a table? I found that in an app I just took over the other day. Was shocked.