数据库试验1VIP免费

南京邮电大学计算机学院《大型数据库技术》实验一： MySQL数据库安装配置及基础使用姓名：侯利萍班级：09 学号： B130409052016 年 3 月 21日 星期一说明：斜体需要输出的部分。下载安装 MySQL 搜索 MySQL下载页面网址：查看各种 MySQL版本MySQL主要版本及区别：所下载版本及版本号：安装配置 MySQL 数据库基本操作创建数据库创建一个企业管理系统数据库，命名为enterprisedb，字符集选择 utf8. SQL语句： create database enterprisedb； set charset utf8；输出截图：创建关系表创建一张雇员表，命名为employee，包括如下字段：雇员工号（从86001开始递增），姓名，性别，生日，部门名称。 （请选择合适的数据类型）SQL语句：create table employe （id int(10) primary key AUTO_INCREMENT,name varchar(10),sex varchar(10),birthday virchar(10)）AUTO_INCREMENT=86001;输出截图：插入数据操作插入 10 条不同信息的雇员，信息自定，需要符合实际。SQL语句： insert into employe values("0","zhang","man","1996.1.2","mangager"); insert into employe values("0","张","man","1996.1.2","mangager"); insert into employe values("0","李","man","1995.1.2","mangager"); insert into employe values("0","胡","woman","1994.1.2","worker"); insert into employe values("0","周","woman","1995.1.1","worker"); insert into employe values("0","郑","woman","1995.3.1","worker"); insert into employe values("0","王","woman","1995.3.1","seller"); insert into employe values("0","吴","woman","1995.2.1","seller"); insert into employe values("0","吴","man","1995.2.1","seller"); insert into employe values("0","赵","man","1989.2.1","leader"); insert into employe values("0","田","woman","19988.2.1","leader"); 注释：在测试英文中文是否都正常时，多输入一个英文员工。输出截图：查询数据显示所有雇员信息SQL语句： select * from employe;输出截图：显示所有男雇员信息SQL语句： select * from employe where sex='man';输出截图：显示所有 1990 年以后出生的雇员信息SQL语句：select * from employe where YEAR(NOW()）-YEAR(birthday)<26;输出截图：删除数据操作删除雇员编号为 86005 的雇员。SQL语句： delect * from employe where id=86005;输出截图：显示所有雇员信息SQL语句： select * from employe;输出截图：修改数据修改雇员编号 86003 的雇员，部门为“规划部”，性别为相反性别。SQL语句： update employe set department="规划区 ",sex="woman"where id="86003";输出截图：显示所有雇员信息SQL语句： select * from employe; 输出截图：