SQL optimization case: implicit conversion

MySQL is one of the most popular relational databases at present. With the rapid development of the Internet, MySQL database is widely used in the production systems of e-commerce, finance and many other industries. In the actual development, operation and maintenance process, we must often encounter the problem of slow SQL. A SQL with poor per ...

Posted by volant on Tue, 10 May 2022 09:16:01 +0300

SQL optimization case: OR condition optimization

Following is an introduction to the previous article, SQL Optimization Case (1): Implicit Conversion, which focuses on OR optimization. In MySQL, the same query condition, if the OR s are transformed in the SQL statement, the results of the query will be different. In many complex cases, poor index selection may be a potential performance hazar ...

Posted by dewbie on Mon, 09 May 2022 19:28:01 +0300

Method of Sql Server Deadlock analysis

environment The Sql Server database is deadlocked. (non emergency or emergency) method 1. RML Utilities tool+Trace File capture deadlock 2. DBCC Capture deadlock 3. Profiler Capture deadlock 4. Trace File capture deadlock(It's time-consuming to execute offline) 5. Automatic deployment Profiler Capture deadlock 6. Service Broker Event n ...

Posted by ClevaTreva on Mon, 09 May 2022 07:07:31 +0300

SQL language multi table query (oracle)

multi-table query When the queried data does not come from one table, you need to use multi table join to complete the query. Query the associated data according to the relationship between the data in different tables. 1, Cartesian product In mathematics, the Cartesian product of two sets X and y, also known as the direct product, repr ...

Posted by grafnic1732 on Sun, 08 May 2022 20:34:12 +0300

SQL basic language collation 2

029 SQL basic query and data update – workbench: Software – query data: select //Query the name of fruit with a price of 10.2 yuan from the fruits table select f_name(,f_price Better look) from fruits where f_price=10.2; – query with in keyword: discrete value //Query s from the fruits table_ Records with IDS 101 an ...

Posted by spamyboy on Sat, 07 May 2022 23:01:58 +0300

About SSM integration, it's enough to read this one ~ (nanny level hand-in-hand tutorial)

SSM (Spring + spring MVC + MyBatis) framework set is integrated by spring and MyBatis (spring MVC is part of spring), which is often used as the framework of web projects with simple data source.          catalogue 1, Create a web project based on maven Management: 1.1 complete the project structure ...

Posted by xxreenaxx1 on Thu, 05 May 2022 12:34:15 +0300

Database Experiment - Triggers and Database Security

📧 Triggers and database security Tip: The general content of this article: This experiment is from topics 7 to 10 of "Database Principles and Technologies" of Tsinghua University Press. 2. P396 on-line experimental questions 8. 3. P396 computer experiment questions 9 topics. Preface 😁 Again, the old saying goes: the basic prin ...

Posted by qazwsx on Wed, 04 May 2022 20:06:17 +0300

HiveSql interview question: continuous check-in and receive gold coins [Baidu - difficult questions - general solution]

catalogue 0 problem description 1 data preparation 2 problem analysis 3 Summary 0 problem description User behavior log table tb_user_log iduidartical_idin_timeout_timesign_in110102021-07-07 10:00:002021-07-07 10:00:091210102021-07-08 10:00:002021-07-08 10:00:091310102021-07-09 10:00:002021-07-09 10:00:42141010 2021-07-10 10:00:00 2021- ...

Posted by erika_web on Tue, 03 May 2022 21:59:16 +0300

[MySQL notes] multi table query

Multi table query, also known as association query, refers to two or more tables completing the query operation together catalogue Prerequisites for multi table query Basic syntax of multi table query Classification of multi table query Equivalent connection and non equivalent connection Self connected and non self connected Internal con ...

Posted by tanita on Tue, 03 May 2022 11:50:59 +0300

Niu Ke interview required real questions SQL chapter 72 full answers - advanced chapter

This article mainly contains the advanced part of the 72 questions in the SQL article, which is a must-tested question in the interview. It mainly includes the more difficult level (18 questions) and the difficult level (4 questions). The questions are more complicated, and my answer may not be the best solution. , Welcome everyone to correct m ...

Posted by glcarlstrom on Mon, 02 May 2022 21:55:06 +0300