having a little trouble why my query is not and displaying. I have looked over this and am not seeing any errors. I am using www.ideone.com to try and test some stuff though it's not working. If I could have an extra set of eyes that would be great. Thanks a bunch.
create table Conflicts
(
ConflictsID int(11),
EmployeeID int(11),
StartTime datetime,
EndTime datetime,
primary key(ConflictsID),
foreign key(EmployeeID) references Schedule(EmployeeID)
);
create table Schedule
(
ScheduleID int(11),
PatientID int (11),
EmployeeID int(11),
AppointmentTime datetime,
AppointmentDescription varchar(256),
AppointmentNotes text,
primary key (ScheduleID),
foreign key(EmployeeID) references Conflicts(EmployeeID)
);
insert into Conflicts values (1,1,08:30:00,05:30:00);
select * from Conflicts;
Aucun commentaire:
Enregistrer un commentaire