Programming VIP

  Introduction to mysql (1) Introduction to MySQL Mysql is a relational database. It is characterized by saving these data in different two-dimensional tables and putting these tables into the database, which can increase its reading speed. (2) Application architecture of mysql Single, suitable for small-scale applications Replicat ...

Swappiness Virtual Memory Swappiness virtual memory is a kernel parameter for Linux. When swap virtual memory is used by the control system, the relative weight of memory usage can be set between 0 and 100. The lower this parameter value is, the less swap virtual memory partitions will be used and the more memory will be used by the Linux ...

1. Query introduction 2. Comparison, logical operation Writing paradigm SELECT <Column name 1>,<Column name 2>, <Column name 3>, ...... FROM <Table name> GROUP BY <Column name 1>, <Column name 2>, <Column name 3>, ......; among The column names in select < column name 1 >, < colu ...

1, Environmental information Internal communication IP Main library: Real_IP.1.5 Standby database: Real_IP.1.6 Standby database: Real_IP.1.7 Arbitration: Real_IP.1.8 Database media path: / home/dmdba/DMSoft/ Mount path: / home/dmdba/DMSoft/dminst Backup, archive, data file path / home/dmdba/{dmbak,dmarch,dmdata} 2, Configure the implemen ...

Return to show.html This page has a delete button. What I want to achieve is that I can click the delete button to call the delete function, execute the delete action, then delete the corresponding information in the database and submit the form The deletion of the show page is for the users of the current page To prevent accidental delet ...

background Recently, some projects need to use Websocket to push real-time to grouped users, and there is less information to be transmitted from the front end to the back end. Through various considerations, we chose to build microservices through the gateway worker framework (based on workman). introduce   Workerman Workerman is an op ...

We need to use SQL statements in many places, such as batch modifying (replacing) content, calling data content, etc. there is a template label {dede:sql /} in the system template for calling data. We can learn how to use this label by referring to the template label instructions in the help center.     Of course, before using and le ...

1, Common field type classification   Common field types typeclassificationdescribeNumerical typeintegerdecimal ① Fixed point number ② Floating point number characterShorter text ①char ②varchar Long text ①text ② Blob (binary data) Date time type 1.1 numerical type   1.1.1 integer characteristic: The integer type is signed ...

summary         DataSource is translated as a data source. It is an interface provided by jdk, and then only provides two getConnection methods, namely, no parameters and the user name and password that need to be passed in. Therefore, it is something related to database connection, which can be used to obtain database con ...

The recently released Elasticsearch 6.3 contains the long-awaited SQL feature. Today, I'll introduce you to the specific usage. First, look at the interface support At present, the supported SQL can only query and read-only data, and cannot modify data. Therefore, our data insertion still needs to go through the previous conventional index in ...