Programming VIP

1. Concept of lock We have learned about multithreading before. How to ensure the accuracy of data in multithreading? Yes, through synchronization. Synchronization is equivalent to locking. What are the benefits of locking? When a thread is really manipulating data, other threads can only wait. When a thread finishes executing, release the lo ...

1. Mysql (master) 1, Create a new master server container instance 3307 docker run --restart=always -p 3307:3306 --name mysql-master \ -v /mydata/mysql-master/log:/var/log/mysql \ -v /mydata/mysql-master/data:/var/lib/mysql \ -v /mydata/mysql-master/conf:/etc/mysql \ -e MYSQL_ROOT_PASSWORD=root \ -d mysql:5.7 Command details --restart=always ...

Common index failures: 1. Condition index field "unclean": Function operation,Arithmetic operation 2. Implicit type conversion: String to value；Other type conversion 3. Implicit character encoding conversion : convert according to the direction with large length of character coded data to avoid data interception 1, Common index fail ...

Tip: After the article is written, the catalog can be generated automatically, how to generate the help document to the right Article Directory PrefaceI. Database Operation StatementPreparedStatementResultSetResultSetMetaData2. Return a record in a table for different table query operationsthree And implement common query operatio ...

4. DQL query data (the most important) 4.1 DQL (date query language: Data Query Language) All query operations use it, selectSimple queries and complex queries are availableThe core language and the most important statement in the databaseMost frequently used statements select[ALL | DISTINCT] { * | TABLE.* | [table.field1[as alias1][,table. ...

2. Operation database Operation database > operation database table > operation database table data 2.1 operation database (understand) 1. Create database create datebase name; 2. Delete database drop datebase name; 3. Use database -- tab Above the key,If your table name or field name is a special character, you need to bring ...

catalogue 1. Concepts of stored procedures and functions 2. Benefits of stored procedures and functions 3. Differences between stored procedures and functions 4. Create stored procedure 5. Call stored procedure 6. View stored procedures 7. Delete stored procedure 8. Stored procedure syntax 8.1 introduction to stored procedure syntax 8 ...

The author's official account is welcome to exchange. 1 background MySQL Group Replication (MGR) is a highly available and highly scalable solution officially launched by MySQL on December 12, 2016. It provides highly available, highly scalable and highly reliable MySQL Cluster Services with the following characteristics: Strong consistenc ...

Author: Yang TaotaoSenior database expert, specializing in MySQL for more than ten years. He is good at backup and recovery, SQL tuning, monitoring, operation and maintenance, high availability architecture design related to MySQL, PostgreSQL, MongoDB and other open source databases. At present, he works in aikesheng, providing MySQL related te ...

[Abstract] preparation of JDBC Java connection MySQL database tool: MySQL driver jar package corresponding to MySQL (database), MyEclipse (development tool) and Navicat (database management tool) (my mql is 8.0, so MySQL connector java-8.0.13. Jar) MySQL connector java-8.0.13 Jar package JDBC Java connection to MySql database Tool preparati ...