Programmer Think

Source: segmentfault.com/a/1190000203866 background The company has a channel system, which is specially connected with three-party channels. There is no business logic. It mainly works on message conversion and parameter verification, which plays a connecting role. Recently, after optimizing the response time of the interface and the code ...

Chapter 1 SQL statements 1.1 SQL overview 1.1.1 introduction to SQL statement The database does not know the JAVA language, but we also need to interact with the database. At this time, we need to use the SQL statement, which is the code of the database. Structured query language (SQL for short) is a standard that relational database managem ...

3, Relational database standard query language SQL 1, SQL overview (1) Composition of SQL language 1. Data definition (DDL) ——Define the logical structure of the database, including basic tables, views, indexes, etc 2. Data manipulation (DML) ——It includes query and update, and update also includes insertion, delet ...

BOM (browser object model) All browsers support window Object that represents the browser window. All js Global objects, functions, and variables automatically become window Object. The global variable is window Object. The global function is window Object. be based on html dom of document Also window One of the properties of the object. wi ...

Java cultivation program -- the 68th day of learning punch in Java (punch in the 68th day) MySQL multi table connection query (MySQL 99) Yesterday, we shared the multi table MySQL l92 syntax of MySQL. The disadvantage of this syntax is to mix the multi table connection conditions with the common filter conditions. At the same time, ...

Installation environment Operating system: CentOS Linux release 7.5.1804 (Core)Database version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production Oracle installation package Link: https://pan.baidu.com/s/1AfUe0fuRJU7Epk3h56EPkQExtraction code: xumw Installation requirements Physical memory: 2GSwitching ...

The interviewer gave a dead order: three servers and build a MySQL master-slave architecture. Can you handle it? I saw that there were 20 minutes before the next interview. OK, I'll finish it for you in 10 minutes and write the document. 1, System experiment environment [root@itlaoxin162 ~]# uname -r 3.10.0-1062.12.1.el7.x86_64 The ker ...

Introduction to redis 1. Redis is an open source (BSD license) memory data structure store used as a database, cache, and message agent. 2. It supports data structures such as strings, hashes, lists, collections, sorted sets with range queries, bitmaps, superlogs, and geospatial indexes with radius queries. 3. Redis has built-in replication, L ...

1, String data type Overview: string is the most basic type of redis. It can store up to 512MB of data. String type is binary secure, that is, it can store any data, such as numbers, pictures, serialized objects, etc 1, SET/GET/APPEND/ STRLEN redis-cli redis 127.0.0.1:6379> exists mykey #Judge whether the key exists, retu ...

1, Single table query Query: users get the data they need from the database table in different ways It is very important and frequent in database operation 1.1 create database 1. Create a new library company 2. Create EMP (employee table) in the company library emp(Employee number empno Employee name empname Employee's p ...