Binary package installation MySQL database

1.1 Binary Pack Installation of MySQL Database 1.1.1 Pre-installation preparation (specification) 1 [root@Mysql_server ~]# mkdir -p /home/zhurui/tools ##Create the specified toolkit storage path 2 [root@Mysql_server ~]# wget http://Ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.5/mysql-5.5.32-linux 2.6- ...

Posted on Wed, 09 Oct 2019 05:11:46 -0700 by richrock

Leetcode Database Title: Employees with the highest salaries in the Department and all employees with the top three salaries in the Department

Look at these two leetcode database topics today     First: The Employee table contains all employee information, and each employee has its corresponding Id, salary and department Id. +----+-------+--------+--------------+ | Id | Name  | Salary | DepartmentId | +----+-------+--------+------- ...

Posted on Tue, 08 Oct 2019 18:24:16 -0700 by MadDawgX

Java JDBC operates on binary data, date and time

binary data mysql provides four types to store binary data: TinyBlob can store up to 255 bytes Blob can store up to 65KB Medium Blob can store up to 16MB LongBlob can store up to 4 GB   1 //from properties Loading database configuration in files 2 Properties properties = new Properties(); 3 InputStream inputStrea ...

Posted on Mon, 07 Oct 2019 22:16:51 -0700 by gasper000

"Play Python" to create one hundred thousand Bowen crawler

Preface Here, for example, to crawl blog articles for reference only, some AD flying websites are too wasteful of the feelings of crawlers. Crawl Use Beautiful Soup to get blog posts Transfer Html to Markdown via html2text Save Markdown to the local file Download the image in Markdown to t ...

Posted on Mon, 07 Oct 2019 21:35:01 -0700 by dmcke5

Docker Installation Stand-alone Canal

I. Docker Installation slightly Modifying MySQL Configuration 2.1 Modify my.cnf configuration For self-built MySQL, you need to turn on the Binlog write function, configure binlog-format as ROW mode, and configure it in my.cnf as follows log-bin=mysql-bin # Open binlog binlog-format=ROW # Select ROW mode server_id=1 # Configuring MySQL repl ...

Posted on Mon, 07 Oct 2019 15:10:43 -0700 by illzz

When mybatis inserts data, it returns the primary key (mysql database)

The first way is to use the useGeneratedKeys attribute Class User public class User { private int id; private String username; private Date birthday; private String sex; private String address; ... mapper file <insert id="insertUser" parameterType="User" useGeneratedKeys="true" keyProperty="id"> insert into u ...

Posted on Mon, 07 Oct 2019 12:55:45 -0700 by zeb

Installation of Lnmp (Multi-PHP Version and Pagoda)

[info] Just a little bit of understanding. It's not really like this. It's all done by docker-compose. Install Lnmp (multiple PHP versions) Download the corresponding mirror version https://hub.docker.com/ Search mirroring docker pull mysql:8.0 docker pull mysql:5.7 docker pull php:7.2-fpm docker pull php:5.6-fpm docker pull nginx:1.15 Create ...

Posted on Mon, 07 Oct 2019 08:41:43 -0700 by power3

Spring Boot Cache Actual Redis

Spring boot uses SimpleCacheConfiguration by default, even using Concurrent MapCache Manager to implement caching. But switching to other cache implementations is also simple. The following is the use of redis as a cache: pom file Introducing corresponding jar packages into pom <dependencies> <dependency> <groupId>org.sprin ...

Posted on Mon, 07 Oct 2019 08:41:03 -0700 by novice_php

Use of Druid Database Connection Pool

Use of Druid Database Connection Pool I. Basic use of Druid_ Druid: database connection pool implementation technology, provided by Steps: 1. Import the jar package druid-1.0.9.jar * Don't forget to import database-driven jar packages 2. Define the configuration file: * It's in the form of p ...

Posted on Mon, 07 Oct 2019 04:39:35 -0700 by emdee

Design and Making of Dynamic Website

Design and Making of Dynamic Website Design and Making mysql Database Creation Statement for Dynamic Website Dynamic website design and production oracle database creation statement Design and production of SQL Server database creation statement for dynamic website Dynamic website design a ...

Posted on Sun, 06 Oct 2019 20:51:33 -0700 by leesiulung