Tag：Full name
-
Time：2021-6-14
preface In previous articles《Angular form validation》This paper mainly introduces some basic knowledge about angular form verification. This article will focus on expanding the relevant content of angular form verification and the application in actual development. Form validation scenario 1 In the actual development, we may have such a situation. We want to be able to […]
-
Time：2021-5-14
Mongodb is a product between relational database and non relational database, which has the most abundant functions and is most like relational database. Mongodb installation Because I’m simply integrating, I’m installing mongodb into windows. 1. Official websiteDownload installation package After entering the download page, you can see the download link directly on the right, select […]
-
Time：2021-4-11
This blog SQL script address: gitee preparation There are four tables as follows: Student form: student (student number, student name, date of birth, gender) Grade: score (student number, course number, grade) Curriculum: Course (course number, course name, teacher number) Teacher table: Teacher 1、 Create databases and tables In order to demonstrate the running process of […]
-
Time：2021-3-13
SQL basic note 3 normal form key What is paradigm? Ha, I can design and use it, but I can’t say it. Then the concept of less clear as a whole What is & classification Normal form (NF) is a kind of specification. When designing a database model, it has different levels of specification […]
-
Time：2021-2-7
catalog Experiment 9: stored procedure experiment Experiment 10: trigger experiment Experiment 9: stored procedure experiment Write and debug 8 stored procedures, master the use of stored procedures. You can also use the assignment in the figure below. SQL statement code –1. Example 1 Use student homework management database; Select * from student table; Select * […]
-
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-26
//Clear screen center function#include#include#include#include#define N 10Int t = 0, a = 0, q = 1, m; / / T is the number of people deleted, a is the serial numberint flag=0;struct Person{Char number [20]; / / student numberChar name [20]; / / nameChar mail [20]; / / emailChar address [20]; / / addressChar Tel [15]; […]
-
Time：2021-1-24
There are four tables as follows: Student form: student (student number, student name, date of birth, gender) Grade: score (student number, course number, grade) Curriculum: Course (course number, course name, teacher number) Teacher table: Teacher According to the above information, write the corresponding SQL statement according to the following requirements. PS: these questions examine the […]
-
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 […]
