Programmer Think

Let's answer the questions before moving on. Two days ago, a little partner asked a question privately and said: What should I do if some tables have sub database and sub table, and the other tables have no sub database and sub table? How can I access normally? This is a typical problem. We know that sub database and sub table are for so ...

1, Foreword The core principle of Mybatis is also the embodiment of its most convenient use. Why? Because when we use Mybatis, we only need to define an interface that does not need to write implementation classes, and we can CRUD the database by annotation or configuring SQL statements. So how do you do this? One very important point is tha ...

1, Basic concepts of database 1. What is a database database is a warehouse used to organize, store and manage data. 2. Common database and classification Common databases include MySQL database, Oracle database (charging), SQL Server database (charging) and Mongodb database. Among them, MySQL, Oracle and SQL Server belong to traditional d ...

Basic knowledge A data storage procedure: Create data - > confirm field - > create data table - > insert data MySQL database system from large to small is: database server, database, data table, row and column. Naming rules for identifiers The database name and table name shall not exceed 30 characters, and the variable name s ...

abstract mysql slap is mysql's own benchmark tool. The tool queries data with simple syntax, flexibility and ease of use The tool can simulate multiple clients to send query updates to the server simultaneously, give the performance test data, and provide the performance comparison of multiple engines. mysql slap provides an intuitive verifica ...

Event driven framework in Redis In the previous article, I learned the basic working mechanism of Redis event driven framework, introduced the Reactor model based on the event driven framework, and took the client connection event in the IO event as an example to introduce the basic process of the framework: calling the aeCreateFileEvent funct ...

Time storage of mysql advanced part Reproduced in guide: https://javagude.cn/database/mysql/some-thoughts-on-database-storage-time/ timestamp is better than datatime 1.datatime will cause time zone problems 2.datatime8 bytes timestamo4 bytes 1. Remember not to store dates in strings I remember doing this when I was in college, and ...

Redis implements the publish / subscribe function, and developers can quickly carry out scenario applications through this lightweight function. SUBSCRIBE,UNSUBSCRIBE and PUBLISH Realized Publish / subscribe messaging paradigm , this decoupling between publishers and subscribers can achieve greater scalability and more dynamic network topology. ...

RH358 configuring MariaDB SQL database – installing MariaDB database Chapter 7 introduces how to configure the database MariaDB. Although it is not deep enough, it is a good start for beginners. It is a more practical chapter in 358 course. 1. Describe the importance of relational databases Relational databases store structure ...

1 cluster 1.1 concept of cluster Today, with the development of the Internet, the magnitude of data is also growing exponentially, from GB to TB to PB. It is more and more difficult to operate the data. The traditional relational database can not meet the needs of fast query and data insertion. One database server can not meet the stor ...