Programmer Think

preface Recently, the teacher of computer class has gone through [database establishment and maintenance], [database table and index creation], [single table query] and [multi table query], but his mind is still messy, so he sorted out this note for future sorting and review. The main content is the query of single table and multi table. ...

Article introduction Many articles on MySQL master-slave replication on the network explain how to implement and some implementation principles, and lack a comprehensive introduction to MySQL master-slave replication. For example, the mode of master-slave replication (semi synchronous mode and asynchronous synchronous mode), the principle ...

This article was written because of a recent need: Known field values for a table are irregular comma-separated strings with the following styles: Now split the field into four fields by comma with the following styles: I have not had a ready-made function in Baidu for a long time, so I can only think of my own way. First of all, the simplest ...

In the process of database operation and maintenance, hardware upgrading, host replacement or test environment based on the current production library are often carried out. At this time, it is necessary to form a target library that is the same as the original library. At this time, physical migration is a more convenient method. Its main purp ...

📢📢📢📣📣📣 Hello! Hello, I'm [IT bond], known as jeames007 in Jianghu, with 10 years of DBA working experience A highly motivated [big data blogger]! 😜😜😜 Member of China DBA Alliance (ACDU), currently engaged in DBA and program programming, lecturer in station B and Tencent classroom, with a live broadcast volume of more than 10W Good at m ...

For a detailed tutorial on the right-click menu bar, please see "making web page right-click menu bar (with mouse attribute)" The layout code is as follows: <!--Right click menu bar dom--> <div class="dom" @*style="display: none;"*@> <ul> <li> <a href="#" style="padd ...

1, Overview Stored procedures can be understood as a collection of SQL statements (equivalent to a function method in PHP to implement business logic). They are compiled in advance and stored in the database. Calling stored procedures has the same effect as directly executing SQL statements, but one advantage of stored procedures is that the ...

The server: Hardware server (personal computer, server in computer room -- blade server)ECS: (Alibaba cloud, Tencent cloud, Huawei cloud, etc.) Software server: You open a service on your PC or (cloud server). (software server). ftp server: default port: 21http server: default port: 80 (Apache, Nginx)https server: default port: 443mysql se ...

This chapter will introduce the school data model and the operation of the school data model table. 1.4 school data model 1.4.1 about this experiment Taking the school database model as an example, this paper introduces the openGauss database, tables, tablespaces, users and other objects, as well as the use of SQL syntax. Suppose that school ...

What is the architecture of master-slave replication? One master and one slave, write from the master library and read from the library The slave library can only be set as read-only, otherwise it will be messy to synchronize the writing of both the master library and the client. What is the role of master-slave replication? The function of ...