MySQL-binlog2sql: non master-slave real-time synchronization + recovery of mistakenly deleted data

MySQL-binlog2sql: non master-slave real-time synchronization + recovery of mistakenly deleted data 1. Introduction 1) Introduction For DBA s or developers, data is sometimes deleted or updated by mistake. If it is an online environment and has a great impact, it needs to be rolled back quickly. The traditional recovery method is to use ...

Added by NoSalt on Wed, 24 Nov 2021 18:14:33 +0200

Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of ORDER BY

preface       Is the mysql version upgraded or the problem after installing mysql added to mysql after mysql 5.7.5_ Node verification. Many functions may not be standardized and cannot be used. 1. Mode I     Simple rough method set @@global.sql_mode =''; -- Directly in mysql The console sets the check ...

Added by MrXander on Wed, 24 Nov 2021 16:12:37 +0200

Mysql review notes - Basics 6 [Database basics]

System environment MAC OS 10.10MySQL version, 5.7.9 Installing mysql on Mac is very simple. Download the installation package from the official website and double-click the installation. There are several places to pay attention to When installing mysql with DMG package on Mac, a root password will be randomly assigned in the last step after ...

Added by Bodhies on Tue, 23 Nov 2021 18:32:21 +0200

Data analysis project - stock data analysis

tushare financial data interface package pip install tushareFunction: provide relevant specified financial dataRelated documents: Tushare - financial data interface package Demand: stock analysis Use the tushare package to obtain the historical quotation data of a stock. tushare financial data interface package, based on which historical tra ...

Added by HektoR on Tue, 23 Nov 2021 07:16:03 +0200

MySQL date and time functions

namedescribeADDDATE()Add time value (interval) to date valueADDTIME()OvertimeCONVERT_TZ()Transition from one time zone to anotherCURDATE()Returns the current dateCURRENT_DATE(), CURRENT_DATESynonym for CURDATE()CURRENT_TIME(), CURRENT_TIMEA synonym for CURTIME()CURRENT_TIMESTAMP(), CURRENT_TIMESTAMPSynonyms for the presentCURTIME()Returns the c ...

Added by fat creative on Mon, 22 Nov 2021 08:33:20 +0200

Experiment 5: trigger and stored procedure (function) - NPU

Experiment 5: triggers and stored procedures (functions)1. For SPJ_MNG database, create and execute the following stored procedures. (40 points in total)(1) Create a stored procedure without parameters - jsearch1. The function of this stored procedure is to return all information of Beijing suppliers in the S table when the stored procedure is ...

Added by jonaofarc on Mon, 22 Nov 2021 03:15:22 +0200

SpringSecurity microservice permission scheme

1. What is micro service 1.1 origin of microservices: Microservices were first proposed by Martin Fowler and James Lewis in 2014. Microservice architecture style is a way to use a set of small services to develop a single application. Each service runs in its own process and uses lightweight mechanisms to communicate, usually HTTP API s. These ...

Added by berridgeab on Sat, 20 Nov 2021 10:45:44 +0200

07 laying a solid foundation: MySQL advanced + JDBC practice

MySQL advanced + JDBC actual combat 1, Database integrity Data integrity (accuracy of data) Function: ensure that the data entered by the user is saved correctly in the database. Ensure data integrity = add constraints to the table when creating a table 1.1 physical integrity Entity: that is, a row in the table represents an entity F ...

Added by stockdalep on Sat, 20 Nov 2021 09:10:19 +0200

DATAX+DATAX-WEB LINUX deployment and usage instructions

1, Required components 1,IDK1.8 2. Mysql5.7 (this version is preferred. There are many pits in other versions of DATAX...) 3,DATAX 4,DATAX-WEB 5. Installation package Baidu network disk resource path: https://pan.baidu.com/s/1xRjxRGQbXWk4IYL2-NrQNQ Extraction code: 8z0x 2, Start installation ** 2.1 installation IDK1.8 ** be careful: If th ...

Added by raven2009 on Fri, 19 Nov 2021 23:32:02 +0200

explain performance analysis

one   table Which table is this query based on. two   type Type is the access type of query and an important indicator The result values from the best to the worst are: system > const > Eq_ ref > ref > fulltext > ref_ or_ null > index_ merge > unique_ subquery > index_ subquery > range > inde ...

Added by lettheflamesbegin on Fri, 19 Nov 2021 10:27:10 +0200