Tag：department
-
Time：2021-1-29
Today’s database experiment is to “master the general method of database application development”, and the development environment is vs (I use version 19 here) 1、 Preparation Operating environment: above win7 DBMS：MySQL 5.5 Development environment: vs19 (12 or above is OK) 2、 Establish engineering project Default template after new project using System; using System.Collections.Generic; using System.Linq; […]
-
Time：2021-1-27
Database and table operation Create, delete and view databases create database mysql1 charset utf8; drop database mysql1; show databases; use mysql1; Create, delete and view tables create table mytab( id int primary key auto_increment, name varchar(50), gender varchar(10) not null, date date, ); //View table structure desc mytab; drop table mytab; Add, update and delete […]
-
Time：2021-1-14
It’s a long way to go. I’ll search up and down. At the end of the week, I’ll continue to take you to learn and review the knowledge of MySQL. Last time we talked about the process control function, let’s continue to learn from the process control function! #5、 Process control function #1. If function: […]
-
Time：2021-1-11
Query syntax: selectList of column names fromTable name list where…. Prepare SQL Create department table CREATE TABLE dept( id INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(20) );Insert into Dept (name) values (‘development department ‘), (‘marketing department’), (‘finance department ‘); Create employee table CREATE TABLE emp ( id INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(10),Gender char (1), — […]
-
Time：2021-1-9
The realization of department management 1. API design description The hierarchical architecture and calling relationship of department business background API are shown in the figure 2. Client implementation 2.1 new department management template Create a new directory named dept control under Src / components / views/ index.vueHere we need to use the tree form, so […]
-
Time：2021-1-3
Subquery exercise db40 List all employees whose salary is higher than Wang Haitao’s, and display their name and salary Select name, Sal from EMP where Sal > (select Sal from EMP where name = “Wang Haitao”); List all employees in the same position as Liu peixia, showing their names and positions. Select name, job from […]
-
Time：2020-12-22
#View #Case: query the student name and professional name of Zhang SELECT stuname,majorname FROM stuinfo s INNER JOIN major m ON s.`majorid`= m.`id` Where S. ` stuname ` like ‘Zhang%’; CREATE VIEW v1 AS SELECT stuname,majorname FROM stuinfo s INNER JOIN major m ON s.`majorid`= m.`id`; Select * from V1 where snail like ‘sheet%’; #1、 […]
-
Time：2020-12-20
–======================Inquiry=========================–Select * from table name –Simple query — query the specified column select the specified column from table nameselect id,name,sex,age from Employee–Note: select age * 14 from employee –Simple query — query the first few lines of information, select top rows * from table nameselect top 5 * from Employee –Query the name, gender and […]
-
Time：2020-12-17
Time in inadvertently, always passed by surprisingly fast. The heat stroke has passed, enter the heatstroke, the sun is more warmly blooming with TA’s light,… The people who are taken care of by the sun outside, you are all industrious and lovely people. You who have been watching this chapter in my house with various […]
-
Time：2020-12-16
Have a good meal, have a good rest, listen to it is very simple, the actual implementation is not so easy. Continue to review the 1999 syntax of MySQL’s multi table query #2、 Sql1999 syntax Grammar: Select query list From table 1 alias [connection type] Join table 2 alias On link condition [where screening criteria] […]
-
Time：2020-12-14
Where is the Northwest Wangxiang, Southeast see the moon several times round. The moon is slowly hanging up in the sky, and I will lead you lovely readers to explore the last subquery part of MySQL. Note: some query results come out, the result screenshot and title requirements are different, there will be redundant fields […]
-
Time：2020-11-9
This is a SQL server data analysis interview question of a company. There are four questions in total. Three of them are selected here. The other one is relatively simple, so it will not be listed. First question: Title:Write a SQL function that splits a string into rows according to the specified separator. […]
