So I have made a table called 'uid' where on uid is the only field in the table. Then I make another table called 'users' where there are two fields, 'uid1' and 'uid2' and both uid values have foreign key constraints referencing the 'uid' field in the uid table.
No problem, tables are created and are all empty.
Then I try inserting a uid varchar value of 'test' into the uid table...
ok works,
Then I try inserting a uid1 and uid2 varchar value of 'test' into the users table...
I get a foreign key constraint error or 1216:
#<MysqlError: Cannot add or update a child row: a foreign key constraint fails>
1216
Does anyone know what I am doing wrong?
Thanks, -Cere
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
