mercredi 6 avril 2016

SQL query not working, using ideone. can't seem to spot error. extra eyes please. (simple query)

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