News for hackers. Stuff that matters.

A comment on Things that don’t work well with MySQL’s FOREIGN KEY implementation. Parent comment

Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by zerocrates on Monday May 01, 2023 @01:30PM (#35776200)
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.
[ Parent | on HN ]
Re:Things that don’t work well with MySQL’s FOREIGN KEY impl... by majora2007 on Tuesday May 02, 2023 @10:30AM (#35788033)
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.
[ Parent | on HN ]