how to insert values in table which contains foreign key
+----------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------+------+-----+---------+-------+
| FACULTY_ID | int(4) | NO | MUL | NULL | |
| COURSE_ID | varchar(8) | NO | MUL | NULL | |
| DATE_QUALIFIED | date | NO | | NULL | |
+----------------+------------+------+-----+---------+-------+
3 rows in set (0.059 sec)
INSERT INTO tbl_isqualified
VALUES
(2143, "ISM 3113", '1998-9-01'); /* (FK),(FK), 'YEAR-MONTH-DAY' */
SELECT * FROM tbl_isqualified;
+------------+-----------+----------------+
| FACULTY_ID | COURSE_ID | DATE_QUALIFIED |
+------------+-----------+----------------+
| 2143 | ISM 3113 | 1998-09-01 |
+------------+-----------+----------------+
1 row in set (0.001 sec)