We are in the age of cloud, system operation and maintenance is simpler and more direct than any other era.
Record your recent steps in deploying the Aliyun server environment and share them with you. Make a record of yourself.
Linux version 2.6.32-696.3.2.el6.x86_64 (firstname.lastname@example.org) (gcc version 4.4.7 201 ...
Added by mikefn on Sun, 26 May 2019 01:54:03 +0300
mysql custom string query function
A function is suitable for processing data formats (fields with','-partitioned data, as well as'-'connected intervals)
Example 1: Data "39570" needed to be judged for field "53678, 45672, 39543-39600" in the table
Example 2: Data "DD.B1.C1.A3,DD.B1.C1.A1-BA,DD.B1.C1.B0" needed ...
Added by bashaash on Sat, 25 May 2019 03:24:41 +0300
MySQL Create Data Table
Creating a MySQL data table requires the following information:
Table field name
Define each table field
The following is the general SQL syntax for creating MySQL data tables:
CREATE TABLE table_name (column_name column_type);
In the following example, we will create the data table runoob_tb ...
Added by j007ha on Thu, 23 May 2019 20:45:50 +0300
A Brief Introduction to Hibernate
In summary, Hibernate is a lightweight persistence framework for ORM that addresses the mismatch between tables in object and relational databases (impedance mismatch) and the advantage that development code does not inherit hibernate classes or interfaces (non-intrusive).The implementation of the Hibernate ...
Added by email@example.com on Thu, 23 May 2019 19:42:20 +0300
MySQL UPDATE Query
If we need to modify or update the data in MySQL, we can use the SQL UPDATE command to operate. . grammar
Following is the UPDATE command to modify the general SQL syntax for MySQL table data:
UPDATE table_name SET field1=new-value1, field2=new-value2
You can update one or more fields at the same time.
1. Introduction to databases
What is a database?(https://www.cnblogs.com/alex3714/articles/5950372.html)
A Database is a warehouse that organizes, stores, and manages data according to its structure.Each database has one or more different API s for creating, accessing, managing, searching, and replicating stored data.We can also store data in f ...
_install mysql-5.6.22 through ansible-playbook batch compilation and initialization, then we only need to start the database to build the database.
ansible-playbook configuration idea:
1. Configure variables through main.yml in vars, mainly source code storage directory and installation directory.
2. Transfer source file ...
Added by rockroka on Wed, 22 May 2019 03:07:02 +0300
Create a Cursor
First create a data table in MySql:
CREATE TABLE IF NOT EXISTS `store` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`count` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7;
INSERT INTO `sto ...
Added by powergen on Tue, 21 May 2019 22:49:25 +0300
I. Several schemes for master-slave replication of MySQL
Database read-write separation is an indispensable and important function for large-scale systems or high-volume Internet applications. From the database point of view, for most applications, from centralization to distribution, the most basic requirement is not the bottleneck of data s ...
Added by cap2cap10 on Tue, 21 May 2019 03:18:58 +0300