Database Administrator

On duplicate key update causes primary key non-continuous auto-increment Solution This feature needs to be implemented in recent projects: To measure the service duration of each software, the client sends a message. If the user's software has been

Dbms_metadata.get_ddl usage Summary In daily work, some people often use tools to view the definition of objects. In fact, it is annoying to view objects in this way. At work, some colleagues asked me how to get the object definition. Today I will

MySQL trigger details Trigger-trigeer is a function used in a database to monitor data changes and trigger certain operations, simply put, a stored procedure is executed before or after a table meets certain conditions. Here we will briefly talk

ERROR 5.7 (HY000) when setting a simple password in MySQL 1819) ERROR 5.7 (HY000) when setting a simple password in MySQL 1819: Your password does not satisfy the current policy requirements. [Problem] Sometimes, you only want to test the password

Oracle tablespace shrinking In Oracle, when creating tablespaces, there is generally no special need to use automatically scalable tablespaces for daily management. In this way, you do not need to monitor the tablespace size in daily situations, we

Oracle background process function description 1. SMON: System Supervision Process1. It mainly refers to the submitted data, but the data file has not been written to the power-off, and the smon will be restored upon restart.A. Perform rollback to

MySQL 5.6.38 optimized instance 1 Introduction: in daily MySQL SQL statement optimization, you will always encounter various problems. Today, we have encountered a strange problem. Here we will record it for your convenience. MySQL version: MySQL 5.6

Rapid deployment of MySQL Databases in Linux1. Download the corresponding software version : Http://mirrors.sohu.com/mysql/MySQL-5.6/ [root@localhost ~]# wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/sql-5.6.36-linux-glibc2.5-x86_64.tar.gz Ii.

Python crawler-uses Baidu map API to crawl data and save it to the MySQL database, pythonmysql First, I have a txt file about the city and the number of parks in the city: Second, use the interfaces provided by Baidu map API to crawl information

Real-time Data Synchronization from SqlServer to MySql--- Install and install mysqlconnectorhttp: // www.mysql.com/products/connector//*ODBC data Manager-> system DSN-> Add-> mysql ODBC 5.3 ANSI driver-> Fill in the data source name, such as jt,

MongoDB entry notes,Installation and configuration manual Installation Curl-O https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.0.6.tgztar-zxvf mongodb-linux-x86_64-3.0.6.tgzcd mongodb (mv mongodb-linux-x86_64-3.0.6.tgz mongodb) mkdir data log

Redis persistence, master-slave and Data Backup (2), redis master-slave data backupRedis has been widely used in the project. To improve redis performance and reliability, we need to know and do the following:Common memory optimization methods and

Article 6: Composite data types-arrays, objects, and nesting, ElasticSearch uses a JSON structure to store data. A Key/Value pair is a JSON field, and a Value can be a basic data type or an array, documents (also called objects), or document arrays.

Python Development --- operate MySQL database, pythonmysql Core Blog content: Reference blog: https://www.cnblogs.com/anpengapple/p/7127580.html1. initial trial operation2. the user logs on to the MySQL database for the first time and causes SQL

C # Upgrade with NewSQL -- TiDB entry,I. background During the previous attempt to CockroachDB (the portal here: http://www.cnblogs.com/Zachary-Fan/p/cockroachdb_net_csharp.html), it was found that migrating from a conventional RDBMS was almost

Oracle Application (interview question example): Important, oracle example (1) ROW_NUMBER () OVER (partition by col1 order by col2) indicates grouping by col1 and sorting by col2 within the group, the value calculated by this function indicates the

MySQL database (python), mysql database python Installation tutorial original web site http://www.cnblogs.com/iscodercn/p/5488633.html MOOC video tutorial Summary Show create table provinces; view encoding, EngineInteger: tingint-> smallint->

What do you know about MySQL? _ Execution plan. mysql understands the execution plan.I. database storage engine View mysql version: View the storage engines supported by the current mysql version: This article only introduces two common storage

Centos 7 system mysql master data synchronization, centosmysql Preparations Master Server IP address 192.168.2.225 Slave Server IP address 192.168.20.8 Mysql master server 1. configure the firewall to allow 3306/tcp ports [Root @ localhost ~] #

SSM integrates Activiti workflow code download and ssmactiviti Workflow Next, I went on to my previous blog and continued. The entire system is composed of Spring + SpringMVC + Mybatis + Maven and other core frameworks. '' The specific