We have a table that contains regular query events (such as the start and end time in calendar events):
TABLE event (
`id` varchar(32) NOT NULL,
`start` datetime,
`end` datetime,
`derived
Tag: mysql
MySQL tables and fields
Database import
File storage data, multiple files are placed in a folder for unified management system
Database classification
mysql installation and use
basic operation of database create show use
MYSQL EXPLAIN details
In our daily work, we will sometimes open slow queries to record some SQL that takes a long time to execute Statement. Finding out these SQL statements does not mean that the job is over. Sometimes
MySQL – Insert Update On Duplicate Key Update
Insert a record into the database. If the primary key value (UNIQUE KEY) of the data already exists in the table, perform the following UPDATE operation. Otherwise, perform the previous INSERT oper
What is the meaning in mysql?
What does group by mean in mysql syntax? After searching for a long time in Baidu, I finally found an article with a better explanation (not a blog post, but Baidu knows it, so depressed, so many n
MySQL index failure scene
For example: a USER table has field attributes name, age, where name is an index
The following are some examples of index failures
1. select * from USER where name=’xzz’ or age=16;
<
MySQL Delete Database
Use ordinary users to log in to the MySQL server. You may need specific permissions to create or delete MySQL databases, so we use the root user to log in here, and the root user has the highest pe
MySQL command summary (3)
MySQL data query
Several common types of conditional query comparison operator <,>,<=, >=,=,!= logical transport symbol and, or, not fuzzy query where field like Value (% stands for r
Mysql – Detect lock table (locked by lock table)
Is there a way to detect locked tables in MySQL? I mean the table locked by the LOCK TABLE table WRITE/READ command.
(Please note that readers interested in detecting named locks acquired usi
Mysql library, table, record, related operations (1)
Library, table, record, related operations (1) Database configuration # The purpose of unified configuration through the configuration file: unified management of the server (mysqld) and client (cl