Programming VIP

1, Internal connection query First create the tables student, course, and exam CREATE TABLE student( uid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, age TINYINT UNSIGNED NOT NULL, sex enum("man", "woman") NOT NULL ); CREATE TABLE course( cid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT, name VA ...

[mysqld] #Set mysql installation directory basedir =/usr/local/mysql #Set the data storage directory of mysql database datadir = /usr/local/mysql/data #Set port port = 3306 socket = /tmp/mysql.sock #Set character set character-set-server=utf8 #Log storage directory log-error = /usr/local/mysql/data/mysqld.log pid-file = /usr/local/mysql/data/my ...

Five data structures of redis Redis is an open source (BSD licensed) in memory data structure storage system, which can be used as database, cache and message middleware. It supports many types of data structures, such as strings, hashes, lists, sets, sorted sets and range queries, bitmaps, hyperlogs and geospatial index radius queries. Redis ...

When we want to operate on the client side of PostgreSQL, we need to access the database from the remote end. At this time, PostgreSQL artifact PostgREST can be launched. PostgREST is a server that can help us generate a series of restful APIs for operating PostgreSQL databases. I also tried to use NGX in Nginx directly before_ The Postgres mod ...

0. Introduction Recently, when synchronizing part of the company's mysql data to es, the Logstash input JDBC for full synchronization，Incremental synchronization with canal However, another problem is that the data structure in ES needs to be redesigned, which leads to the need for some mysql fields to be transformed and then synchronized to ...

MySQL Learning Series For some very performance-consuming statements, MySQL still tries its best to convert this bad statement into a more efficient form according to some rules. This process can also be called query rewriting. Conditional simplification The search condition of the query statement we write is essentially an expression. The ...

Five common data types of centos7 redis Redis key commandeffectkey *View all key s in the current libraryexists keyDetermine whether a key existstype keyView the type of keydel keyDelete the specified key data (delete directly)unlink keySelect non blocking deletion (asynchronous deletion) according to value. Only keys are deleted from the met ...

preface: Database notes 1, What is a database DataBase (DB, DataBase)Concept: database, also known as data management systemFunction: save and safely manage data (such as addition, deletion, modification, query, etc.) to reduce redundancy 2, Classification of database 2.1 relational database (SQL) There are MySQL, Oracle, Sql Sev ...

introduction:This paper prefers practice rather than methodology. The writing method of SpringBoot unit test mentioned in this paper is not an official solution, but a writing method that the author thinks is more convenient and efficient. Each team and even each developer in the team may have their own writing habits and styles. As long as the ...

Build a database: CREATE DATABASE `mybase` Building tables CREATE TABLE `t2` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(20) NOT NULL DEFAULT '1' COMMENT 'Full name', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 The difference between change and modify modify Modify constraints, such as modifying ...