Slow SQL statement of PostgreSQL

Author: Song Shaohua 1, Reading guide Optimization is very important to improve the performance of the database itself in the case of hardware and non system failures. Each type of database has its own different ways to track and optimize the database. These methods include not only the optimization of the parameters of the database system it ...

Posted on Wed, 10 Nov 2021 01:43:12 -0500 by Arnold_26

SQL Server - SQL data query language (DQL)

5. Connection query Sometimes, you need to use a SELECT statement to query data in multiple tables. For this purpose, you can use join queries. Connection query is divided into inner connection, outer connection, cross connection and self connection. Inner connection and outer connection are common connections; The result of cross connection i ...

Posted on Tue, 09 Nov 2021 21:06:02 -0500 by psgarcha

SQL injection (query method and blind injection)

Many injections have no echo, which may be caused by the problem of SQL query method. At this time, we need to use relevant error reporting or blind injection for subsequent operations. sql statement addition, deletion, modification and query: For example, insert statement injection can be used to inject into the database during user reg ...

Posted on Tue, 09 Nov 2021 20:19:00 -0500 by MikeX

WAF bypass - SQL injection

WAF bypass - SQL injection Conduct operations on data, such as case, encryption and decryption, encoding and decoding, so as to make the interception invalid For example, take sqlilabs-less-2 as an example (assuming that the security dog has been set to prohibit querying the database): At this point, when you enter the following statement ...

Posted on Tue, 09 Nov 2021 18:16:00 -0500 by Bryan Ando

Basic operation of mysql database

MySql 1) Data Definition Language (**DDL * *) such as database and table building 2) Data Manipulation Language(**DML * *), such as adding, deleting and modifying records in a table 3) Data Query Language(**DQL * *), such as query operations in tables 4) Data Control Language(**DCL * *), such as setting user permissions   Addition, delet ...

Posted on Mon, 08 Nov 2021 17:18:47 -0500 by codygoodman

SQL server data query

preface This paper briefly summarizes the data query statements and reviews what I wrote when reading Basic grammar Single line note:-- Multiline comment / **/ 1, Single table query 1. Select several columns in the table --Query specified column select sno, sname from student; --Query all columns select * from student; --Query ...

Posted on Mon, 08 Nov 2021 06:49:09 -0500 by Gorf

Introduction to database system -- database single table query

1, Experimental purpose Master the basic syntax of SELECT statement and the expression method of query conditions;Master query condition expression and usage;Master the function and usage of GROUP BY clause;Master the function and usage of HAVING clause;Master the function and usage of ORDER BY clause. 2, Experimental class hours 2 class hou ...

Posted on Sun, 07 Nov 2021 01:54:28 -0400 by MidOhioIT

Complete analysis of Boolean blind injection of SQL injection

Injection principle Boolean blind annotation is applicable when there is no echo during injection. The principle is that the application system makes Boolean judgment when querying according to the where+and statement, that is, the result is true or false, for example, select * from admin where id=1 and 1=1. In general, the application sys ...

Posted on Sat, 06 Nov 2021 00:49:00 -0400 by slak

mysql learning (basic grammar)

sql classification DDL (data definition language) database definition language Some sql used when creating table views, such as CREATE, ALTER, DROP, etc. DDL is mainly used to define or modify database, table and view structures DML (data manipulation language): These are the SELECT, UPDATE, INSERT and DELETE that we most often use. It is mainl ...

Posted on Fri, 05 Nov 2021 22:37:47 -0400 by fatmikey

MySQL tutorial Chapter 03 managing databases

The Database in MySQL is like a container, which contains various objects. For example, data tables, views, stored procedures, and triggers. Among them, the Table is the main object for storing data. The relationship between them is shown in the figure below:This chapter mainly introduces the creation, viewing, selection and deletion of databas ...

Posted on Thu, 04 Nov 2021 19:33:01 -0400 by peteraub