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
Category: Database
The database is a warehouse that organizes, stores and manages data according to the data structure. It was created more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management is no longer just It is to store and manage data, and transform it into various data management methods required by users. There are many types of databases, from the simplest tables that store various data to large-scale database systems that can store massive amounts of data. They have been widely used in all aspects.
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
Limit the row as a sum of a column equal to a value in MySQL
I want to write a query that returns all rows until the sum of the values in one column reaches a certain value.
For example, in the following table:
DATE ETC Meeting
2013-02-01 00:0
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