Tag:achievement

  • Zset (ordered set) of redis’s five data types

    Time:2021-9-3

    On the basis of set, a value is added, set K1 V1, Zset K1 Score1 v1 127.0.0.1:6379 [1] > zadd myset 1 one # add a value (integer) 1 127.0.0.1:6379 [1] > zadd myset 2 two 3 # add multiple values (integer) 2 127.0.0.1:6379[1]> ZRANGE myset 0 -1 1) “one” 2) “two” 3) “three” 127.0.0.1:6379 […]

  • Informatics events

    Time:2021-8-14

    Tsinghua University and Peking University compete to admit them. What is the Informatics Olympiad_ Mobile Sohu Why are Tsinghua and Peking University competing for top students in informatics competition? You’ll know after reading it_ Mobile Sohu​m.sohu.co Remember this sentence: as long as you can enter the University, everything is easy to say How to win […]

  • [database] MySQL exercises and answers (educational administration management system)_ MySQL_ 5.7)

    Time:2021-7-28

    ✨ statement The answer to the exercise is not guaranteed to be completely correct, which is for reference only MySQL:5.7 Recommended software: Navicat premium Learning SQL statements requires diligent practice! ✨ Field description of each table course CId Course serial number, primary key PCId Prerequisite course DId Opening department number, foreign key CName Course name […]

  • Fifty SQL statements (MySQL version) problems

    Time:2021-7-17

    ————————–Table structure————————– Student (studid, studname, studage, studex) student table Teacher (TID, tname) teacher table course(CId,Cname,C_ TID) curriculum sc(SId,S_ CID, score) ———————————————————- Question 17: according to the average score from high to low, all students’ scores of “database”, “enterprise management” and “English” courses are displayed in the following forms: Student ID, database, enterprise management, English, number […]

  • Fifty SQL statements (MySQL version)

    Time:2021-7-5

    ————————–Table structure————————– Student (studid, studname, studage, studex) student table Teacher (TID, tname) teacher table course(CId,Cname,C_ TID) curriculum sc(SId,S_ CID, score) ———————————————————- Question 22: query the transcripts of students from the third to the sixth place in the following courses: business management (001), Marx (002), UML (003), database (004) format: [student ID], [student name], business management, […]

  • Java   Version of student performance management system, with source code!

    Time:2021-7-3

    preface For students majoring in computer science, they must be very impressed by the course design of student performance management system. Design, computer, coding, report writing, defense and a series of processes, although very simple, but we can also use some of our knowledge. Today, let’s review the following topic, using java se to realize […]

  • 50 SQL statements (MySQL version) problem analysis

    Time:2021-7-2

    ————————–Table structure————————– Student (studid, studname, studage, studex) student table Teacher (TID, tname) teacher table course(CId,Cname,C_ TID) curriculum sc(SId,S_ CID, score) ———————————————————- Question 25:Query the records of the top three scores of each subject (regardless of the juxtaposition of scores) SELECT * FROM (SELECT s1.S_CId,s1.Score,COUNT(DISTINCT s2.Score) Rank FROM sc AS s1 INNER JOIN sc AS s2 […]

  • C + + homework – score statistics

    Time:2021-6-28

    Achievement statistics 1) Write a function randscore to generate an integer of [0100] interval( Tip: use rand function) int randScore(){ int num = rand() % 101; return num; } 2) Write a function, using the above randscore function, randomly generate the results of a course for the whole class. void stuRandomScore(int stuScore[]){ for (int i […]

  • Group sorting function — row_ number()

    Time:2021-6-14

    1. MySQL 8.0 or above Usage 1: no grouping sort Row_ Number() over (order by field DESC)For example: row_ Number () over (order by DESC)All students are ranked from high to low, regardless of classUsage 2: Group sortROW_ Number () over (division by field 1 order by field 2 DESC)It means to group according to […]

  • SQL exercise 1 (50 with answers)

    Time:2021-6-9

    SQL exercises 1. Table structure – 1. Student table Student(s_ id,s_ name,s_ birth,s_ Sex) – student number, student name, date of birth, student gender – 2. Curriculum Course(c_ id,c_ name,t_ ID) –– course number, course name, teacher number – 3. Teacher list Teacher(t_ id,t_ Name) – teacher number, teacher name – 4. Score sheet Score(s_ […]

  • SQL server transaction details (transaction isolation and isolation level details)

    Time:2021-6-5

    summary Many people’s use of affairs is limited tobegin transaction: start transactioncommit transaction: commit transactionrollback transaction: the initial application of rollback transaction. We also know that after using the transaction, all the operation commands in the transaction must be committed or rolled back as a whole. If any operation command in the transaction fails, the […]

  • 50 SQL interview questions

    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 […]