vue+node+mySql to separate front and back end

Environment building Install node first: http://nodejs.cn/download/ Download and install it directly! The new version does not need to manually configure the environment. After installation, open cmd and input node-v and npm-v to check whether the installation is successful. The second step is to install vue: T ...

Posted by Concat on Wed, 01 Apr 2020 13:05:01 +0200

New tablespaces and corresponding users of Oracle database based on database technology

New tablespaces and corresponding users in Oracle Database Create tablespace and temporary tablespace data files Create a tablespace data file SQL> CREATE TABLESPACE rec_news LOGGING DATAFILE '/home/oracle/OracleDB/user/rec_news/rec_news.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 5120M EXTENT MANAGEMENT LOCAL; Ta ...

Posted by SpasePeepole on Wed, 01 Apr 2020 03:05:27 +0200

MySQL parallel replication records updated from the database do not exist, but exist

Parallel replication records updated from the library do not exist, but exist background The semi synchronous slave database SQL thread with parallel replication enabled reports 1032 errors, while the asynchronous slave database does not report any errors. This happens occasionally Analysis Version mysql 5.7.16 mysql> show variables like '%s ...

Posted by johnkelly on Tue, 31 Mar 2020 08:41:14 +0200

[MyBatis] learning summary 6: dynamic SQL

Introduction Dynamic SQL: dynamic SQL. In this section, we will learn from the official documents of MyBatis. Description The official description is as follows: One of the most powerful features of MyBatis has always been its Dynamic SQL capabilities. If you have any experience with JDBC or any similar framework, you understand how painful it ...

Posted by Squiggles on Mon, 30 Mar 2020 23:25:00 +0200

MySQL data definition language (DDL)

SQL consists of the following four parts: 1 data definition language (DDL): DROP, CREATE, ALTER and other statements. 2 data operation language (DML): INSERT, UPDATE and DELETE statements. 3 data query language (DQL): SELECT statement. 4 data control language (DCL): GRANT, REVOKE, COMMIT, ROLLBACK and other statements. DDL(Dat ...

Posted by zaneosak on Mon, 23 Mar 2020 16:38:48 +0100

MySQL field constraint and multi table query

The field constraint of mysql is inevitable in the future. There are four main contents as follows: the primary key constraint is used for uniqueness and cannot be empty; the non empty constraint cannot be empty and can be repeated; the unique constraint can be empty but must be unique; the foreign key constraint is to make a certain associatio ...

Posted by Candrew on Mon, 23 Mar 2020 12:04:35 +0100

MySQL task scheduling tool EVENT

Summary MySQL EVENT is a scheduled task, similar to crontab task on LinuxIt mainly has the following properties In mysql, the objects of timing events are globally unique event performs operations according to the schedule, including one SQL operation. You can also use begin and end to implement multiple SQL composite execution The permission ...

Posted by Otiose Dodge on Fri, 20 Mar 2020 11:42:24 +0100

Detailed explanation of total record optimization of count query in paging component

1 background When using the paging function of mybatis plus (hereinafter referred to as MBP). Found a JsqlParserCountOptimize The official didn't give a detailed introduction to the paging optimization processing class of, and didn't find a few words on the Internet to analyze the logic of this class, which we dare not use. It's also convenient ...

Posted by silas101 on Wed, 18 Mar 2020 08:21:33 +0100

Calling stored procedures and functions using JDBC

Original Link: http://www.yiidian.com/jdbc/jdbc-callablestatement.html 1 CallableStatement interface The CallableStatement interface is used to call stored procedures and functions. By using stored procedures and functions, we can write business logic on the database, which will improve performance because they are precompiled. 2 What is the di ...

Posted by msurabbott on Wed, 18 Mar 2020 04:02:52 +0100

Spring-4-database connection pool, JDBC Template, transaction control

The content of the content 1. Database connection pool * concept and function         * C3P0         * Druid * Custom JDBC tool class     2. Spring JDBC : JDBC Template 3. Transaction control in Srping##Database connection pool 1. Concept: in fact, it is a container (Collection) for database connecti ...

Posted by brewfan9 on Sat, 14 Mar 2020 11:51:54 +0100