Today, I have discussed the problem of Database Transaction Processing with my colleagues. I feel that the discussion is clear and I have read some knowledge, but I still don't understand it if I haven't actually used it.
Transaction processing is
/** Check whether the event is Enabled: show variables like '% event_sche %'; enable the event plan: set global event_scheduler = 1; disable the event plan: set global event_scheduler = 0; close EVENT task: alter event eventName on completion
In databases, we often encounter the following situation: A primary table A, A subtable B, and table B contain the primary key of Table A as the foreign key. When you want to insert data, we will first insert Table A, then obtain the Identity of
MySQL logical architecture:
Concurrency Control: Implemented by locks
Read locks: Also known as shared locks. Read locks do not block each other. After A locks the table, A, B, c, and d can read the table but cannot write it.
Write lock: Also called
This is the first article about SQL optimization.
Here, I mainly express my point of view that if an index does not exist, it should be eliminated, leaving it in the way.
During the period from 15:39:01 to 15:55:00, we found two problems in a
Fault status: the php website fails to connect to mysql. However, you can use the mysql command in the command line to log on and operate normally.Solution:1. log on to mysql under the command line and execute the following command:Copy codeThe Code
If you forget the MySQL root Password, You can reset it using the following methods:
1. KILL the MySQL process in the system;
2. Run the following command to start MySQL without checking its permissions;
Mysqld_safe-skip-grant-tables &
3. Use
1. Aggregate functions
Aggregate functions are functions that run on a row group to calculate and return a single value.
SQL Aggregate functions
Function
Description
AVG ()
Returns the average value of a column.
Here, the blog simply aims to extract some common mysql operations. If you already understand this, you can ignore it. Thank you.Basic mysql operations
1. query mysql version and current time information
Select version (), current_date,
1. Functions
Function portability is not very strong. Different DBMS has different functions.
2. Text processing functions
Function
Description
Left ()
Returns the character on the left of the string.
1. Fields
Fields are similar to column meanings. Database columns are generally called columns, and fields are generally calculated fields.2. Splice Fields
Join -- connect values together to form a single value
Concat () function
SELECT Concat
When updating a table using mysql workbench, the following exception is reported:
Error Code: 1175. To disable safe mode, toggle the option in Preferences-> SQL Editor-> Query Editor and reconnect.
You are using safe update mode and you tried to
Mysql connection query:
MysqlConnection query supports multi-Table connection
Get a table:
Method 1: (subquery and connection query are mixed)
Step 1:
result.id, t_name h_name,match_time,result teams result
Before writing code, you must:
1. Introduce the assembly System. Data. dll in C: Program FilesUnityEditorDataMonolibmonounity (My unity is installed on the C drive by default ).
2. Copy the System. Data. dll file to the Current Unity project file,
When we were hired to monitor MySQL performance, people wanted us to check MySQL configurations and give some suggestions for improvement. Many people are surprised afterwards, because we suggest that they modify only a few settings, even if there
1. SQL statement. insert is followed by 1000 values for one-time submission. 2. use the connection pool to keep the persistent connection inserted; 3. replace the storage engine of Mysql with Inforbright, convert the data into text, and import data
I. Problems Encountered
In fact, it is not a big problem O (distinct _ distinct) O: Sometimes we may want to directly process the select result set in batch processing or stored procedures. At this time, we need a database object that allows us to
Log on to a mysql server today and enter mysql-u root-p and press Enter. The error message is as follows:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)
I followed the online password change method and did
The embedded MySQL version is getting weaker and weaker. It happened that a small application used it and recorded it by the way.For more information, see.We hope that the following simplified steps will play a role.1. Download the code and compile
The bow whispered to the arrow, "Your freedom is mine ". Schema is like an arrow and bows like Python. Choosing Python is the biggest freedom of Schema. Freedom should be an opportunity to make yourself better.
(I) MySQLdb Section Mysql> use sakila;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service