MySQL common sentences and practical training

> input Description: nothing output Description: emp_no birth_date first_name last_name gender hire_date 10008 1958-02-19 Saniya Kalloufi M 1994-09-15   The answer:select * from employees order by hire_date desc limit 0,1; 1 2     second questions:     Find all staff members with the third lowest ranking time of entry staff.CREATE TABLE `employees` (`emp_no` int(11) NOT NULL,`birth_date` date NOT NULL,`first_name` varchar(14) NOT NULL,`last_name` varchar(16) NOT NULL,`gender` char(1) NOT NULL,`hire_date` date NOT NULL,PRIMARY KEY (`emp_no`)); > input Description: nothin...

Three paradigms of database

First normal form (1NF):Emphasis is placed on atomicity of columns, that is, columns can not be further divided into other columns.  Consider such a table: “contact” (name, gender, telephone).If in the actual scenario a contact has a home phone and a company phone, the meter structure is not designed to reach 1NF. To conform to 1NF, we simply split the columns, i.e. [contacts] (name, sex, home phone, company phone). 1NF is a good judge, but2NF and 3NF are easy to mix up.◆ Second normal form (2NF):The first is 1NF, which contains two other parts. The first is that a table must h...

Dichotomy search JS algorithm

dichotomy search algorithm:When dichotomy is used to search, data needs to be arranged in order.The main idea is: (set the array interval to find is array[s, e]).(1)Determine the middle position of the interval M(2)Comparing the search value T with array [m], if the search is equal, the search returns to this location successfully; otherwise, the new search area is determined and the binary search continues.The area is as follows:Array is arranged from small to large.array[m]>TFrom the order of arrays, we can see array[m,… E]> T;Therefore, the new interval is array[s,R...

Docker introduction

1. dockerinstall #dockerInstallation sudo apt-get install docker.io #Method of canceling common user sudo #1. Create docker group: sudo groupadd docker #2. Add the current user to group docker: sudo gpasswd -a ${USER} docker #3. Restart service: sudo service docker restart #4. Refresh docker members: newgrp - docker   2. image Find and download mirrors #Look up the mirror docker search centos docker search mysql #Download mirroring (lastest for mirror version, without specifying default latest) docker pull mysql:latest docker pull centos:latest Mirror operation 1 # List the mirroring ...

JS case six _1: add city

Related knowledge points: add to child nodes: document.appendClild () Creation of text nodes: document.createTextNode () Creation of element nodes: document.createElement () <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> <script> window.onload = function() { document.getElementById("btn").onclick = function() { //1.Get UL nodeVar ulEle = document.getElementById ("ulEle");//2, Chuang JianwenThis nodeVar textNode = document.createTextNode ("Gao Song");//3, ...

Oracle database to modify data files

Each log group contains at least one log member. To be safe, it is recommended that each log group contain more than two members, and each log member is located at a different location.diskWhen writing logs, Oracle will write the same content into multiple members of the same log group. There are at least 2 log groups, with the same size in each group and at least 1 members. View log file groups and members; SYS@testdb> select group#,bytes/1024/1024 M,members from v$log;  Additional members in log group SYS@testdb> alter database add logfile member ‘/u01/app/oracle/oradata/tes...

Xcode

Xcode” to use > simulator shortcut key cmd + shift + h Homekey > search paths for configuring static and dynamic link libraries. Click on project document Select Build Setting and All in TARGETS, type search in the search bar, and find Library Search Paths Enter the directory you need. When you configure OpenCV, you can link libraries in this way, but that’s the only way to report errors, because each library in / usr / local / lib has a lot of versions, and the compiler doesn’t know how to choose, so look for libraries based on the linker’s current directory char...