create table classroom(
id int primary key auto_increment,
build_buildnumber_id int foreign key(build_buildnumber_id) references build_buildnumber(build_buildnumber_id),
buildlevel_classroom_id int foreign key(buildlevel_classroom) references buildlevel_classroom(buildlevel_classroom),
classroom_useful_id int foreign key (classroom_useful_id) references classroom_useful(classroom_useful_id),
day_time_id int foreign key(day_time_id) references day_time(day_time_id),
week_start_end_id int foreign key (week_start_end) references week_start_end(week_start_end_id)
);
select week_start_end.week_start_end_id
from week_start_end,classroom_useful
where week_start_end.start=classroom_useful.start and
week_start_end.end=classroom_useful.end;
select day_time.day_time_id
from day_time,classroom_useful
where day_time.day=classroom_useful.day and
day_time.time=classroom_useful.time;
select build_buildnumber.build_buildnumber_id
from build_buildnumber,classroom_useful
where build_buildnumber.build=classroom_useful.build and
build_buildnumber.buildnumber=classroom_useful.buildnumber;
access denied for user ‘root’@‘localhost’(using password:YES)
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
insert
into user
(username,userpassword)
values(‘Tom’,‘123456’)
;
create table user(
id int primary key auto_increment,
username varchar(20),
userpassword varchar(20)
);