摘要: --创建学生表 create table students ( id int unsigned not null auto_increment primary key, name varchar(20) default '', age tinyint unsigned default 0, high 阅读全文
posted @ 2018-11-26 19:43 aclover 阅读(601) 评论(0) 推荐(0)
摘要: 视图 视图本质就是对查询的封装 创建视图(定义视图 起名以v_开头) create view v_students as select classes.name as c_name ,students.* from students inner join classes on students.cl 阅读全文
posted @ 2018-11-26 16:28 aclover 阅读(465) 评论(0) 推荐(0)