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
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)
Extract hive inst ...
Posted on Fri, 21 Feb 2020 06:06:37 -0800 by chrisuk
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
1, Project preparation
Use the source code of the previous chapter directly
2, Add mapper4 dependency
<!-- mapper4 -->
Posted on Thu, 20 Feb 2020 20:49:43 -0800 by parkie
PostgreSQL, alicloud, real-time precision marketing, crowd selection, advertising
Almost all industries, such as Internet, new retail, education, games, etc
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
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
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
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
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
Chapter one: dynamic agent
1.1 - transfer case
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
CREATE TABLE account(
id INT PRIMARY KEY AUTO_INCREMENT,
)CHARACTER SET utf8 COLLATE utf8_general_ci;
Posted on Sat, 15 Feb 2020 23:14:45 -0800 by IceDragon