Keywords and reserved words Keywords are words that have significant meaning in SQL. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special handling for use as identifiers such as table and column names. This may also apply to the names of built-in functions. Allow non-reserved keywords as identifiers without quotes. Reserved […]
Tag: mysql
MySql 8.0 version keywords
A|B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|X | Y | Z A ACCESSIBLE (R) ACCOUNT action ACTIVE; added in 8.0.14 (nonreserved) ADD (R) ADMIN; became nonreserved in 8.0.12 AFTER AGAINST AGGREGATE ALGORITHM ALL (R) ALTER (R) ALWAYS ANALYSE; removed in 8.0.1 ANALYZE (R) AND (R) ANY ARRAY; added in 8.0.17 (reserved); became nonreserved in 8.0.19 AS (R) ASC (R) ASCII ASENSITIVE […]
Java realizes real-time monitoring of MySQL database changes MySQLBinListener
Directory 1. Export the required classes and interfaces 2. Define the MySQLBinlogListener class 3. Private method to start the reconnection timer 4. Complete code Write a listener for real-time changes to the MySQL database. Why write this listener: In order to monitor and respond to change events in the MySQL database in real time Real-time […]
MySQL data export csv file – a lot
Recently, I encountered a demand for downloading files. Exporting the data in mysql to a file in csv format should be quite simple. However, the amount of data is too large, and there are millions of data in the table. Conditions of hundreds of thousands of data. Step 1: To optimize the sql index, return […]
Efficient solution: It only takes 13 seconds to insert 300,000 pieces of data into MySQL
Click to follow the official account, Java dry goodsdelivered in time This article mainly describes the cases and results of large data volume data insertion through MyBatis, JDBC, etc. 300,000 pieces of data are inserted into the database for verification Entity class, mapper and configuration file definition User entity mapper interface mapper.xml file jdbc.properties sqlMapConfig.xml […]
Lock mechanism and principle of MySql database
MySQL is a popular relational database management system widely used in various web applications and enterprise applications. In MySQL, a lock is a mechanism for controlling concurrent access, which can ensure data consistency and integrity. This article will introduce the locking mechanism and principle of MySQL, including the type, level and implementation principle of the […]
C++ self-service order program based on MySQL
One, system function 1. View menu details 2. Add dishes to the shopping cart 3. Remove the dish from the shopping cart 4. View my shopping cart details 5. Empty my shopping cart dishes 6. Menu administrator authentication 7. Admin option: add dishes to the menu 8. Admin option: delete dishes from the menu Note: […]
Mysql storage time, corresponding to Api and corresponding java properties
1. Mysql storage time type Commonly used types of time/date storage: DATE: Only used to store date values (year, month, day) in the format ‘YYYY-MM-DD’. TIME: Only used to store time values (hours, minutes, seconds) in the format ‘HH:MM:SS’. DATETIME: used to store date and time values at the same time, the format is ‘YYYY-MM-DD […]
MySQL index optimization practice & EXPLAIN analysis
Let’s introduce the specific business scenario first When the user logs in, he needs to view the courses that he can learn. Different users see different courses. The courses have permissions. The permissions are controlled by the following lesson_user_permissions table, where sys_user_id and lesson_id are used as the joint primary key There is also a […]
Index coverage, index pushdown, index diving, index merging for MySQL query performance optimization
Index coverage What is index coverage The data columns of select can only be obtained from the index without reading the data rows, in other words, the query columns must be covered by the built index. How to achieve index coverage? The most common method is: build the field to be queried into a joint […]