mysql

mysql的安装链接
https://www.sogou.com/tx?query=mysql8.0.12安装&ie=utf8&_ast=1554947072&_asf=null&w=01025001&pid=sogou-site-1f2b8183cd1e469a&duppid=1&cid=&cid=&s_from=result_up&oq=安装mysql8.&ri=1&sourceid=sugg&suguuid=a9c65e3f-3164-4490-a81d-9a61d293eadb&stj=1%3B19%3B0%3B0&stj2=0&stj0=1&stj1=19&hp=76&hp1=&suglabid=suglabId_1&sut=3061&sst0=1554947039575&lkt=2%2C1554947037423%2C1554947038069&sugsuv=1554940865801435&sugtime=1554947039575

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)
);

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值