getting an auto_incremented integer..
Posted 13 October 2006 - 06:34 AM
Posted 15 March 2008 - 04:26 AM
This is the table I have created with auto_increment:
CREATE TABLE appointment(appointment_id MEDIUMINT NOT NULL AUTO_INCREMENT, Primary Key (appointment_id), student_id varchar(, INDEX (student_id), FOREIGN KEY (student_id) REFERENCES student(student_id), lecturer_name varchar(50), INDEX (lecturer_name), FOREIGN KEY (lecturer_name) REFERENCES lecturer(lecturer_name), appointment_date DATE, appointment_time TIME) TYPE=INNODB;
Is the auto increment value also set as a primary key through Primary Key (appointment_id) or does it overide the primary key and its rules?
Posted 15 March 2008 - 04:14 PM
Head Shops and Grow Stores and
Find Motorcycle/ATV Repair, Tires
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users