@ Echo off
Rem sets the service of the XP System
Common functions of REM SC .exe:
Rem 1. Change the service startup status.
Rem 2. Delete the Service (otherwise it is not recommended to delete any system service, especially the basic service with caution)
Rem 3. Stop or start a service (the function is similar to net stop/start, but more services are faster and can be stopped)
Rem command format:
Rem modifies the command line format of t
Label:SELECT * from Student;SELECT * from Courseselect;select* from Teacherselect;SELECT * from SC;--Create test dataCREATE TABLE Student (s# varchar), Sname nvarchar (ten), Sage datetime,ssex nvarchar (10))INSERT into Student values (' ', n ' Lei ', ' 1990-01-01 ', n ' Men ')INSERT into Student values (' 1990-12-21 ', n ' money Electric 'INSERT into Student values (' ', n ' Sun Wind ', ' 1990-05-20 ', n ' Men ')INSERT into Student values (' ', n ' Le
1. Check the driver used by the network card[Email protected] ~]# ethtool-i em1driver:tg3version:3.122firmware-version:ffv7.4.8 BC 5720-v1.30bus-info:0000:01:0 0.02. See where TG3 is located[Email protected] ~]# locate-r Tg3.*ko/lib/modules/2.6.32-279.el6.x86_64/kernel/drivers/net/tg3.koBecause the system kernel driver module ends with a. Ko3. View module Information[[emailprotected]~]#modinfo/lib/modules/2.6.32-279.el6.x86_64/kernel/drivers/net/ Tg3.kofilename:/lib/modules/2.6.32-279.el6.x86_64
>>>>>>>>>>Practice Time: 2016.12.16Editing time: 2016-12-20-->22:12:08 title :related to: multi-table query, exists, COUNT (), group BY, order by1.1Relationship ModeStudent Student;SNO: study number;SNAMEName AgeAgeSEX: GenderCourse Course: CNO: Course code, CNAME: Course name, TEACHER: TeacherStudent Performance SC: SNO: School Number, CNO: Course code, score: Score1.2Requires a SQL language to complete the creation of tables and the insertion of dat
SQL interview test (Part 1), sqlpart
This article is inOn the basis of the original Cat Qi post, the notes implemented by myself in the MySql database by question are continuously updated...
Refer to the original post:Http://www.cnblogs.com/qixuejia/p/3637735.html
01 table structure
Student (Sno, Sname, Sage, Ssex) Student tableCourse (Cno, Cname, Tno) CurriculumSC (Sno, Cno, score) Orders tableTeacher (Tno, Tname) Instructor table
02 create a table and insert Test Data
(1) create a table:1 drop
Problem description:Create three tables to manage job business training information:Student (stu_no, stu_name, stu_workunit, age)
Stu_no, stu_name, stu_workunit, and age indicate the student ID, Student name, unit, and age respectively.
Class (cla_no, cla_name)
Cla_no. cla_name indicates the course number and Course name respectively.
SC (stu_no, cla_no, score)
Stu_no, cla_no, and score indicate the student ID, number of the selected course, and score
your administrator name and password as you modify the file. The Arjunolic ASP probe can be used to detect the security status of the system.
One Key Shutdown service batch
Copy Code code as follows:
Cls
MODE con:cols=80 lines=18
COLOR 70
Echo.
Echo is doing system service optimization, please wait a moment ...
@:: Alerter
@:: Notifies selected users and computers to manage alerts. If the service is stopped, programs that use administrative alerts will not receive them. If
Server
Topic 2
Problem Description:Known relationship pattern:S (sno,sname) student relationship. SNO is the school number, sname is the nameC (cno,cname,cteacher) course relationship. CNO is the course number, CNAME is the course name, Cteacher is the instructorSC (Sno,cno,scgrade) elective relationship. Scgrade for grades
The following 5 processing requirements are achieved:1. Find out the names of all the students who have not been enrolled in the course by Li Ming Teacher2. List the names of
Explain common SQL statements with four tables for students, courses, scores, and instructors. First, let's look at the relationship between the four tables.
Student (s #, sname, sage, ssex) Student table
Course (C #, cname, T #) Curriculum
SC (s #, C #, score) Orders table
Teacher (T #, tname) Instructor table
Clear and clear, the following uses SQL to create a table structure:
Create Database db_school;Use db_school;Drop table t_student;Create Table
Use the CMD command to manually, automatically start, and disable servicesTIPS: use command line to start the service
You can open the service in cmd in two ways: net, SC, and net. The syntax is as follows:Net start service name start Net start service nameStop net stop service nameNet stop service name
(Service name: Right-click the service -- Property -- General -- service name, rather than the display name)
Use
-- 1. The following table shows the information of all students, sorted in ascending order of student numbers, and displayed in alphabetical order of course names for the same student number. -- Student ID Student name Course name score selectst. studno, st. studname, sum (decode (cc. coursename, JAVA, SC. grade, 0) JAVA, sum (decode (cc. c
-- 1. The following table shows the information of all students, sorted in ascending order of student numbers, a
S (SNO, sname) Student Relationship. Sno is the student ID, and sname is the name
C (CNO, cname, cteacher) Course relationship. CNO is the course number, cname is the course name, And cteacher is the course teacher
SC (stu_no, cla_no, score) Course Selection relationship. Score
Initialization table:
Insert into S values ("001", "zhangsan"); insert into S values ("002", "padern"); insert into S values ("003 ", "wangwu"); insert into S values ("004", "X
Label:SQL statement Exercises 50 questions Student (sid,sname,sage,ssex) Student table Course (cid,cname,tid) curriculum SC (Sid,cid,score) Table Teacher (tid,tname) Teachers table Practice content:1. Check the number of all students who have a "1" course with a higher grade than "a 2" course;Select A.sid from (select Sid,score from SC where cid=1) A, (select Sid,score from
required for the model card [8,086:1521 ] Support.05, check whether the target core network card driver supports the current model cardThe Modinfo command allows you to see *.ko support for which device model, the driver for the target core (2.6.33-110.el6.x86_64) can be/lib/modules/2.6.33-110.el6.x86_ The catalog of "want to find", as follows:#modinfo/lib/modules/2.6.33-110.el6.x86_64/kernel/drivers/net/igb/igb.ko
Filename:igb.koVersion:2.1.0-k2License:gplDescription:intel (R) Gig
Create a student tableCreate a score tableCreate a teacher tableCreate a grade Table--1, Query the sname, Ssex, and class columns of all records in the student table. SELECT S.sname, S.ssex, S.classFrom student S--2, query teachers all units that are not duplicated depart column. SELECT DISTINCT depart from teacher--3, querying all records of the student table. SELECT*From student--4, query all records in the score table with scores from 60 to 80. SELECT* FROM score
Most of the SQL statements in this statement come from "Introduction to Database System" (fourth edition) Wang Shan Shaman Xuan Munsu, is our class with the teaching materials, feel very good, summed up the third chapter of the SQL statement, more practical, I hope to help everyone. Summarized below, can be used to learn the underlying SQL statements.Set up a databaseCREATE DATABASE db_studentCreate a tableCREATE TABLE Student(Sno CHAR (9) PRIMARY KEY,--main codeSname CHAR,--Unique valueSsex CH
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.