Tag:Full name
-
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-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-29
1、 SQL query is used to express the following queries for the three basic tables s, SC and C in the teaching database S (SnO, sname, sage, ssex) fields indicate student number, name, age and gender Each field of SC (SnO, CNO, grade) represents student number, course number, grade Each field of C (CNO, CNAME, […]
-
Time:2020-12-19
The verification code generation tool used in Python projects:gvcodeAndcaptcha gvcode Full name: Graphic verification code Installation: pip install gvcode use: import gvcode s, v = gvcode.generate () sequence unpacking s. Show() ාdisplays the generated captcha image Print (V) ා print captcha string effect: captcha Installation: pip install captcha use: from captcha.image import ImageCaptcha […]
-
Time:2020-12-16
——————System stored procedure——————-–The stored procedure defined by Microsoft and can be used directly is called system stored procedure–System procedure_ XXXexec sp_helpdb master exec sp_bindrule —————–Custom stored procedure——————-–Stored procedures defined by programmers –Extended stored procedure —-==================The creation of stored procedure has no parameters===============——Definitioncreate procedure proasbegin declare @x int set @x=1 while @x<10 begin print […]
-
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-30
When doing a project, there will always be an element or button, which needs to be processed in different functions under different requirements. Here we take the table table as an example, which I use here vue.js And element As shown in the figure: (you can click the name or double-click the name) Functional […]
-
Time:2020-11-21
Author: attapulgite Zhu Feifei background Recently, I received a request to develop the react component library. During the development process of the component library, I just finished writing a component to be used by my colleagues. My colleague immediately asked me, “ah? How to use this component. Emmm, I thought I’d just tell it I’d […]
-
Time:2020-11-10
Introduction to Oracle Oracle database, also known as Oracle RDBMS, referred to as Oracle. It is a relational database management system launched by Oracle.Oracle database system is a popular relational database management system in the world. It has the advantages of good portability, easy to use and strong function. It is suitable for all kinds […]
-
Time:2020-11-7
Flink provides the corresponding dataset API and datastream API in order to process bounded and unbounded datasets. We can develop corresponding Java programs or Scala programs to complete the corresponding functions. Here are some examples of the basic operators in the dataset API. Next, we will demonstrate the role of each operator through specific code. […]
-
Time:2020-11-5
Name = input (“> > > Name:) QQ = input(“>>>QQ: “) phone_ Num = input (“> > > mobile number:) com_ Addr = input (“> > > Company Address”)) print(“=” * 30) Print (“\ nname: S / N / NQQ: S / N / n mobile number: S / N / N company address: S […]
-
Time:2020-11-4
Multi sheet import tutorial explain This tutorial explains how to use it Magicodes.IE.Excel Complete the excel import of multiple sheet data. main points Importing multiple sheet data of the same format Multiple sheet data import with different formats Main steps 1. Import multiple sheet data with the same format 1.1 create dto to import sheet […]