weixin_47672692的博客

多表查询：学生表、班级表、课程表、班级课程表--多对多--班级表CREATETABLEbanji(idINTPRIMARYKEYAUTO_INCREMENT,`name`VARCHAR(10)NOTNULL);INSERTINTObanji(`name`)VALUES('java1807'),('java1812');SELECT*FROMbanji;--学生表CREATETABLE...

create table goods (goods_id mediumint(8) unsigned primary key auto_increment,goods_name varchar(120) not null default '',cat_id smallint(5) unsigned not null default '0',brand_id smallint(5) unsigned not null default '0',goods_sn char(...