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

Changgou Mall (the first day)

Environment building Information: Cloud disk connection Extraction code: sb1m After getting the data, decompress the virtual machine, and open Centos-changgou.vmx with VMware virtual machine software, Then open, user name: root, password: 123456. The environment used in the later stage has been instal ...

Posted on Fri, 14 Feb 2020 09:19:00 -0800 by ronald29x

Get the background user name and password of the website by detecting sql injection vulnerability through sqlnamp

lnmp environment needs to be built in advance Install sqlmapproject sqlmap [root@ localhost ~]# tar -xvzf sqlmapproject-sqlmap-1.0.9-87-g7eab1bc.tar.gz [root@ localhost ~]# cd sqlmapproject-sqlmap-7eab1bc/ [root@ localhost sqlmapproject-sqlmap-7eab1bc]# python sqlmap.py Unzip DVWA master to the r ...

Posted on Fri, 14 Feb 2020 06:39:42 -0800 by Valdoua

MySQL basic simple operation 03

MySQL basic simple operation Now I create a data table with the following contents: mysql> select * from gubeiqing_table; +----------+-----+ | name | age | +----------+-----+ | gbq | 21 | | zhangsan | 20 | | lisi | 22 | +----------+-----+ 3 rows in set (0.00 sec) I now need to sort the data in ascending order by age. mysql&gt ...

Posted on Thu, 13 Feb 2020 12:02:14 -0800 by vandalite

Principle of ansible, installation, various modules in detail

What is ansible? Ansible is a new automated operation and maintenance tool. It is developed based on Python and combines the advantages of many operation and maintenance tools (puppet, cfengine, chef, func, fabric). It realizes the functions of batch system configuration, batch program deployment, batch running commands and so on.Ansible is m ...

Posted on Sun, 09 Feb 2020 09:49:02 -0800 by like_php

Host list for ansible, yml syntax, playbook details + operations

Contents of this chapter:inventory host list2. yml grammar3. playbook Details + Operations inventory host list ansible The default host list is/etc/ansible/hosts file //Host lists can be set manually or generated dynamically through Dynamic Inventory //Use FQDN for generic hostname vi /etc/ansible/hosts [webserver] #Square bracket set ...

Posted on Sun, 09 Feb 2020 09:28:59 -0800 by cybercrypt13

Take and return json data in flask

json data structure: take the city data of package ticket website as an example, don't panic to get the data, 1. Analyze the data structure first. There are several large fields ('returnCode' and 'returnValue' fields. Only one field is defined and the other field is reserved (no need to deal with) 2 key table - > split 're ...

Posted on Sun, 09 Feb 2020 09:05:50 -0800 by netzverwalter

Two database connection modes and two annotations (annotation version usermapper, file version)

1, Two ways to connect database Method 1: springboot is configured by default (DataSource and sqlsessionfactory) Direct configuration file application.yml Write inside spring: datasource: url: jdbc:mysql://127.0.0.1:3306/o2odb?serverTimezone=UTC&characterEncoding=utf-8&useSSL=true ...

Posted on Sat, 08 Feb 2020 06:42:52 -0800 by haku87

SpringBoot integrates MyBatis and transaction management

Integrated MyBatis (1) Add dependency in pom.xml <!-- mybatis It depends on the start of. Contains mybatis,mybatis-spring,spring-jdbc(The coordinates used by the transaction) --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter& ...

Posted on Sat, 08 Feb 2020 06:05:59 -0800 by juschillinnow