MySQL ders scheduler

0 Cevap php

Bu yüzden bana almak için mevcut dersler içeren aşağıdaki tablo var:

"CREATE TABLE courses 
(
subject varchar(15), 
course int,
day varchar(15),
timein double,
timeout double,
courseID int
)";

For example: subject= ECON, course= 101, day= M, timein= 9.0, timeout= 10.3, courseID= 11. I need to find a MySQL script that will give me all possible combinations of the courses without having a time conflict. Thanks

0 Cevap