Tag：sql statement
-
Common queries for xml mapping files of the mybatis framework
When using the mybatis framework, there will inevitably be a query statement for the database, so this article hopes to help you. What is Mybatis framework? MyBatis is an excellent persistence layer framework that supports custom SQL, stored procedures, and advanced mapping. MyBatis avoids almost all JDBC code and manually setting parameters and getting result […]
-
Oracle database business SQL optimization practice – time interval query case
background There are actually many query fields, I choose to focus on the bottleneck point, let’s get started Functional Background Brief: We set up a machine at the entrance of the data center to record the entry and exit of personnel, and the guards will operate and record the entry and exit of personnel […]
-
The ultimate solution for SqlServer startup error (cannot find one or more c)
@[toc] problem arises When I opened my SQLserve last night, I found that this window popped up, and I started a long solution. Finally, I tried almost all the tutorials on the Internet, but it was useless! !Let’s review other bloggers’ solutions: 1.Perfect solution to SqlServer2012 startup error (cannot find one or more components. Please […]
-
SQL Abstract Syntax Tree and Rewriting Scenario Application
1 Background We usually write various simple or complex sql statements, and after submitting, we will get the result set we want. For example, the sql statement, “select * from t\_user where user\_id > 10;”, is intended to filter out all records with user\_id greater than 10 from table t\_user. Have you ever thought about […]
-
PostgreSQL Security Best Practices
The database is the “holy grail” in the eyes of hackers, and we need to treat it with the same care as the “flower”. This article focuses on best practices for database protection. First, starting with PostgreSQL, the most commonly used open source database, we will introduce several security layers that you need to consider: […]