centos6, 7, redhat linux system 5 steps automatic backup mysql database script, simple and easy to use

1. First create a backup folder mkdir /usr/local/database_backup/ cd /usr/local/database_backup/ 2. Create. sh execution file and write code vim mysqlbak.sh   #!/bin/bash PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin export PATH #Database username dbuser='root' #Password ...

Posted on Thu, 03 Oct 2019 05:15:06 -0400 by signer

Mysql Specifies Partial Data Synchronization

I. Demand Background A friend's company needs to synchronize part of the data from the source to the target at regular intervals every day. There are tables of company_id column in the library, which only import the specified company_id column into the target database; there are tables of company_id column, which import all the data from the t ...

Posted on Thu, 03 Oct 2019 04:48:46 -0400 by aaronhall

Realization of a Simple Student Management System

package jdbc; import java.sql.ResultSet; import java.util.Scanner; import com.zzu.util.DBUtil; public class Student { public static void main(String[] args) { System.out.println("*********************************"); System.out.println("*\t\t\t\t*"); System.out.println("*\t Welcome to use ...

Posted on Wed, 02 Oct 2019 23:20:09 -0400 by joeman3429

Android Operates SQLite Database (Preliminary) - Delete Database in Programs

Links to the original text: https://my.oschina.net/qiuzhping/blog/611693 In particular, how Android deletes databases, because SQLite does not provide instructions to drop database XX, ...

Posted on Wed, 02 Oct 2019 22:27:17 -0400 by linuxdoniv

EF Data Migration

  EF automatic data migration is always a failure. At the beginning, it is all right. It can migrate automatically and fail to know why it always fails. I can only move it manually. ----------------------------------------------------------------------------- This time, attributes are added to a ...

Posted on Wed, 02 Oct 2019 18:30:21 -0400 by metalblend

springboot Multiple Data Source Configuration

In practical development, we often encounter the situation that multiple databases may need to be accessed in an application, so we need to use switching data sources to achieve our function, that is, the configuration of multiple data sources. Environment is spring boot Configure the slave database ...

Posted on Wed, 02 Oct 2019 18:00:23 -0400 by little_tris

python interacts with database mysql

Operate mysql through pycharm's concise code block to help us understand The concrete steps can be divided into five steps. 1. Install and install the pymysql Library pip install pymysql Import pymysql Library import pymysql 2. Link to the database. Here we use a dictionary to receive it. db_conf ...

Posted on Wed, 02 Oct 2019 09:46:37 -0400 by Tomatron

Jsp Learning Notes-Paging Query

Core sql i What page is it? itemNum Number of data bars displayed per page select * from ( select e.*,rownum rn from ( select * from employee where 1=1 order by empno) e where rownum <(i*itemNum)) where rn >(i-1)*itemNum General thinking Using Page class encapsulation (Page is used as a parameter of a method in the Dao class, ...

Posted on Wed, 02 Oct 2019 06:14:32 -0400 by byronbailey

Stored Procedures in MySQL--Introduction

1. what storage process? Official note: Stored Procedure is a set of SQL statements for specific functions in a large database system. It is stored in a database and is permanently valid after a compilation. The user fills in the parameters (if any) by specifying the stored procedure name. ...

Posted on Wed, 02 Oct 2019 03:51:34 -0400 by daveoliveruk

Creation of triggers in PostgreSQL environment

Create SQL statements for table triggers CREATE TRIGGER example_trigger BEFORE INSERT ON teaches FOR EACH ROW EXECUTE PROCEDURE example_function();   Example: First create test tables, views CREATE TABLE COMPANY( ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50 ...

Posted on Wed, 02 Oct 2019 01:23:48 -0400 by fluvius