3 Solved Topics
Remove Filter
|
|
Hi all. I'm developing a quiz application consisting of multiple choice questions. Here are the tables that I've come up with. CREATE TABLE IF NOT EXISTS `student` ( `s_id` int(10) NOT NULL, `s_name` varchar(30) NOT NULL, `s_email` varchar(30) NOT NULL, PRIMARY KEY (`s_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF … |
|
Hi all, I'm having some trouble inserting records into my MySQL db because of how I've set up my foreign keys. The problem is, I don't know how to fix it to make it do what I need it to. Here is my schema: http://imgur.com/t5bVt Here is my php code … |
|
hi every one. i have two tables table_1 ( std_id primary key, std_name, tchr_id foreign key ); table_2 ( tchr_id primary key, tchr_name ); as from the above tables i have the foreign key constraint. it mean if i want to delte teacher id it must be firstly deleted from … |
The End.