MySQL must know must know 19-23 chapters

Chapter 19-23 The nineteenth chapter INSERT is used to INSERT (or add) rows to database tables. There are several ways ·Insert full row ·Insert part of row ·Insert multiple rows ·Insert results of some queries MySQL security can be used for each table or user to prohibit ...

Posted on Mon, 24 Feb 2020 03:02:21 -0800 by sathyan

[Hadoop big data platform component building series] - Hive component configuration

brief introduction This article introduces the build of Hive component in Hadoop big data platform component (MySQL needs to be built before build Hive) Use software versionapache-hive-1.1.0-bin.tarmysql-connector-java-5.1.47.jar (Baidu cloud extraction code: vk6v) Install Hive Extract hive inst ...

Posted on Fri, 21 Feb 2020 06:06:37 -0800 by chrisuk

Deployment LAMP dynamic static separation

1, LAMP dynamic and static separation When it is necessary to build an efficient web architecture, dynamic static separation is undoubtedly the best choice. This blog will write down the dynamic static separation deployment mode of LAMP. So called LAMP? LAMP architecture is one of the most mature application modes of enterprise website. It re ...

Posted on Fri, 21 Feb 2020 03:41:17 -0800 by Dedix

Spring Boot: Spring Boot integrates Mapper4

1, Project preparation Use the source code of the previous chapter directly 2, Add mapper4 dependency <!-- mapper4 --> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper-spring-boot-starter</artifactId> <version>2.0.2</version> ...

Posted on Thu, 20 Feb 2020 20:49:43 -0800 by parkie

Selected cases of Alibaba cloud PostgreSQL real time precision marketing and crowd selection

Label PostgreSQL, alicloud, real-time precision marketing, crowd selection, advertising background Industry: Almost all industries, such as Internet, new retail, education, games, etc Application scenario: According to the characteristics of the target group, the target group is extracted quickly For example, In the e-commerce industry, be ...

Posted on Thu, 20 Feb 2020 20:15:39 -0800 by Rustywolf

Sharding JDBC distributed primary key

In the traditional enterprise software development, the technology of automatic generation of primary key is the basic requirement. Each database provides corresponding support for the requirement of the self-increasing primary key, such as MySQL's self-increasing key. For MySQL, it is very troublesome for different databases and tables to gene ...

Posted on Thu, 20 Feb 2020 04:01:56 -0800 by pleisar

Overview of Spring Data JPA

Overview of Spring Data JPA 1.1 overview of spring data JPA Spring Data JPA is a set of JPA application framework based on ORM framework and JPA specification. It enables developers to access and operate the database with simple code. It provides common functions including addition, deletion, modif ...

Posted on Wed, 19 Feb 2020 19:50:00 -0800 by itsmeArry

Selected cases of seven principles of internal mental skill and software architecture design of Architects

1, Seven principles of software architecture design 1.1 open closed principle (OCP) The principle of opening and closing is that a software entity such as class, module and function should be open to extension and closed to modification. The so-called opening and closing is also a principle for expansion and modification. The emphasis is to ex ...

Posted on Tue, 18 Feb 2020 23:02:43 -0800 by techjosh

Mysql internal connection, left connection, right connection query

The table creation statement is as follows To create a table: -- ---------------------------- -- Table structure for a_table -- ---------------------------- DROP TABLE IF EXISTS `a_table`; CREATE TABLE `a_table` ( `id` smallint(6) AUTO_INCREMENT, `name` varchar(10) Not NULL, `phone` varchar(11) ...

Posted on Sun, 16 Feb 2020 22:47:27 -0800 by formxshape

Spring framework - Part 3

Chapter one: dynamic agent 1.1 - transfer case 1.1.1- demand Account A transfers 100 yuan to account B Account A minus 100 Account B plus 100 1.1.2 - database script CREATE DATABASE IF NOT EXISTS db1 USE db1 CREATE TABLE account( id INT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(40), money FLOAT )CHARACTER SET utf8 COLLATE utf8_general_ci; INS ...

Posted on Sat, 15 Feb 2020 23:14:45 -0800 by IceDragon