![](https://img-blog.csdnimg.cn/20190918140213434.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
数据库sql
文章平均质量分 66
sql软件安装,sql语句,前端php
jennie佳妮
准华为云解决方案架构售前工程师SA(海外)。That which does not kill me,makes me stronger。虽然辛苦,但是我还是会选择那种滚烫的人生。莫问前程,但行好事,天道酬勤。愿你有十足的少年意气,只向自己的梦想俯首,而不必字斟句酌的考量世俗人心。
展开
-
MYSQL数据库SQL语句练习实验 EXERCISES 7 Data Manipulation
Create a new table called loans with columns named LNO NUMERIC (3), EMPNO NUMERIC (4), TYPE CHAR(1), AMNT NUMERIC (8,2) create table loans2019274072(LNO NUMERIC(3) PRIMARY KEY,EMPNO NUMERIC(4),TYPE CHAR(1),AMNT NUMERIC(8,2)); Insert the fo.原创 2021-12-10 22:27:57 · 468 阅读 · 0 评论 -
MYSQL数据库SQL语句练习实验 EXERCISES 6 SUB QUERIES.
List the name and job of employees who have the same job as Jones. select ename,job from emp2019274072 where job=(select job from emp2019274072 where ename='jones'); Find all the employees in Department 0 that have a job that is the same as any.原创 2021-12-10 22:14:56 · 556 阅读 · 0 评论 -
MYSQL数据库SQL语句练习实验 EXERCISES 5 GROUP BY & HAVIN
List the department number and average salary of each department. select deptno,avg(sal) from emp2019274072 group by deptno; Divide all employees into groups by department and by job within department. Count the employees in each group a...原创 2021-12-10 22:08:35 · 397 阅读 · 0 评论 -
MYSQL数据库SQL语句练习实验 EXERCISES 4 DATES
Select the name, job, and date of hire of the employees in department20. (Format the HIREDATE column to MM/DD/YY) Select ename,job,date_format(hiredate,' %m/%d/%Y') from emp2019274072 where deptno=20; Then format the HIREDATE column into Do...原创 2021-12-10 21:37:07 · 759 阅读 · 0 评论 -
MYSQL数据库SQL语句练习实验 EXERCISES 3 FUNCTIONS
Find how many employees have a title of manager without listing them. Select count(ename) from emp2019274072 where job=’manager’; Compute the average annual salary plus commission for all salesmen. Select ename,ave(sal+comm) from emp201...原创 2021-12-10 21:24:37 · 732 阅读 · 0 评论 -
MYSQL数据库SQL语句练习实验 EXERCISES. 1 SIMPLE COMMANDS
EXERCISES. 1 SIMPLE COMMANDSList all information about the employees. Select * from emp2019274072; 图 15 题1.12.List all information about the departmentsSelect * from dept2019274072;图 16 题1.23.List only the following info...原创 2021-12-10 20:58:10 · 2150 阅读 · 1 评论 -
MYSQL数据库SQL语句练习实验 EXERCISES 2 JOINS
Find the name and salary of employees in Luton. Select ename,sal from emp2019274072,dept2019274072 where emp2019274072.deptno=dept2019274072.deptno and loc=’luton’; Join the DEPT table to the EMP table and show in department number order. Sel原创 2021-12-10 21:06:45 · 491 阅读 · 0 评论 -
利用mysql wampserver创建数据库及表格
wampserver数据库建表赋值,包括图形化界面和控制台命令文件导入2种方式。原创 2021-12-10 20:33:27 · 2614 阅读 · 0 评论 -
wampserver安装
下载安装包到本地,点击运行或点击桌面快捷键图 2 点图标打开2.打开后桌面右下角显示绿色软件标志符,表示计算机软件配置成功;若为红色或黄色则表示配置失败或部分失败,需要手动调试。图 3 桌面右下角会有绿色可服务的软件托盘2.点击这个桌面右下角绿色软件标志符,选择phpMyAdmin,进入浏览器下的服务器: mysql wampserver图 4 进入图形化界面...原创 2021-12-10 05:50:01 · 388 阅读 · 0 评论