1. Equivalence comparison: = 4
2. Comparison of unequal values: <> 4
3. Less than comparison: < 4
4. Less than or equal to comparison: <= 4
5. Greater than comparison: > 5
6. Greater than or equal to comparison: >= 5
7. NULL value judgment: IS NULL 5
8. Non-null judgment: IS NOT NULL 6
9. LIKE comparison: LIKE 6
10. LIKE operation in JAVA: RLIKE 6
11. REGEXP operation: REGEXP 7
2. Mathematical operations: 7
1. Addition operation: + 7
2. Subtraction operation: - 7
3. Multiplication operation: * 8
4. Division operation: / 8
5. Remainder operation: % 8
6. Bit AND operation: & 9
7. Bitwise OR operation: | 9
8. Bit XOR operation: ^ 9
9. Bit negation operation: ~ 10
3. Logical operations: 10
1. Logical AND operation: AND 10
2. Logical OR operation: OR 10
3. Logical NOT operation: NOT 10
4. Numerical calculation 11
1. Rounding function: round 11
2. Specify the precision rounding function: round 11
3. Round down function: floor 11
4. Round up function: ceil 12
5. Rounding up function: ceiling 12
6. Get a random number function: rand 12
7. Natural exponential function: exp 13
8. Base 10 logarithmic function: log10 13
9. Base 2 logarithmic function: log2 13
10. Logarithmic function: log 13
11. Power operation function: pow 14
12. Power operation function: power 14
13. Square root function: sqrt 14
14. Binary function: bin 14
15. Hexadecimal function: hex 15
16. Reverse hexadecimal function: unhex 15
17. Base conversion function: conv 15
18. Absolute value function: abs 16
19. Positive remainder function: pmod 16
20. Sine function: sin 16
21. Arcsine function: asin 16
22. Cosine function: cos 17
23. Arc cosine function: acos 17
24. positive function: positive 17
25. negative function: negative 17
5. Date function 18
1. UNIX timestamp to date function: from_unixtime 18
2. Get the current UNIX timestamp function: unix_timestamp 18
3. Date to UNIX timestamp function: unix_timestamp 18
4. Convert date in specified format to UNIX timestamp function: unix_timestamp 18
5. Convert date and time to date function: to_date 19
6. Date conversion function: year 19
7. Date to month function: month 19
8. Date to day function: day 19
9. Date to hour function: hour 20
10. Date to minute function: minute 20
11. Date to second function: second 20
12. Date week rotation function: weekofyear 20
13. Date comparison function: datediff 21
14. Date add function: date_add 21
15. Date reduction function: date_sub 21
6. Conditional function 21
1. If function: if 21
2. Non-empty search function: COALESCE 22
3. Conditional judgment function: CASE 22
4. Conditional judgment function: CASE 22
7. String functions 23
1. String length function: length 23
2. String reversal function: reverse 23
3. String concatenation function: concat 23
4. Delimited string concatenation function: concat_ws 23
5. String interception function: substr, substring 24
6. String interception function: substr, substring 24
7. String to uppercase function: upper,ucase 24
8. String to lowercase function: lower,lcase 25
9. Space removal function: trim 25
10. Function to remove spaces on the left: ltrim 25
11. Function to remove spaces on the right: rtrim 25
12. Regular expression replacement function: regexp_replace 26
13. Regular expression parsing function: regexp_extract 26
14. URL parsing function: parse_url 26
15. json parsing function: get_json_object 27
16. Space string function: space 27
17. Repeat string function: repeat 27
18. The first character ascii function: ascii 28
19. Left complement function: lpad 28
20. Right complement function: rpad 28
21. Split string function: split 28
22. Set search function: find_in_set 29
8. Set statistical functions 29
1. Count statistical function: count 29
2. Sum statistical function: sum 29
3. Average statistical function: avg 30
4. Minimum statistical function: min 30
5. Maximum statistical function: max 30
6. Non-empty set overall variable function: var_pop 30
7. Non-empty set sample variable function: var_samp 31
8. Overall standard deviation function: stddev_pop 31
9. Sample standard deviation function: stddev_samp 31
10. Median function: percentile 31
11. Median function: percentile 31
12. Approximate median function: percentile_approx 32
13. Approximate median function: percentile_approx 32
14. Histogram: histogram_numeric 32
9. Composite type construction operation 32
1. Map type construction: map 32
2. Struct type construction: struct 33
3. Array type construction: array 33
10. Complex type access operations 33
1. Array type access: A[n] 33
2. Map type access: M[key] 34
3. struct type access: S.x 34
11. Complex type length statistical function 34
1. Map type length function: size(Map<K.V>) 34
2. Array type length function: size(Array<T>) 34
3. Type conversion function 35

Statement of this Website
All resources on this website are contributed and published by netizens, or reprinted by major download sites. Please check the integrity of the software yourself! All resources on this website are for learning and reference only. Please do not use them for commercial purposes, otherwise you will be responsible for all consequences incurred! If there is any infringement, please contact us to delete and remove it. Contact information: admin@php.cn

Related recommendations

Android development tutorials and notes pdf version

Android file access and database programming knowledge. File operations mainly include reading files, writing files, reading static files, etc. It also introduces creating, adding file content and saving, opening files and displaying the content; database programming mainly introduces the SQLite database. The use includes knowledge of creating, deleting, opening databases, non-query SQL operation instructions, query SQL instructions-cursors, etc.
Mobile terminal
2024-02-29

Unity3d game development camera switching Chinese WORD version

This document mainly talks about camera switching in unity3d game development; I hope it will be helpful to everyone; interested friends can come and take a look.
Other manuals
2024-02-29

Android Chinese API collection chm version

Android Chinese Translation Group - A collection of Android Chinese APIs. API documentation (Reference) is the basis of Android development. In the past three years (2007-2010), the official Chinese version of the API has not yet been released. The Android Chinese Translation Group has gathered a group of people to engage in Android development. People, forum moderators, college students, graduate students, etc. use their spare time to translate Android APIs. The number of people has grown from 1 to 80, and the number of published translations has ranged from 1 to 50.
Mobile terminal
2024-02-29

Lucene learning and summary Chinese WORD version

This document mainly talks about the learning and summary of Lucene; Lucene is an efficient, Java-based full-text search library. I hope this document will help friends in need; interested friends can come and take a look.
Other manuals
2024-02-29

Maven series

Some companies do not provide external networks for programmers, so maven cannot be used to access remote warehouse addresses, so it is necessary to find a machine in the LAN that has external network permissions; build a nexus private server, and then programmers connect to this private server In this case, you can access the maven remote warehouse through this computer with a nexus private server. Interested friends can come and take a look
Other manuals
2024-02-29

Netty code analysis Chinese WORD version

This document mainly talks about Netty code analysis; Netty provides asynchronous, event-driven network application framework and tools to quickly develop high-performance, high-reliability network server and client programs; friends in need can download and read look
Other manuals
2024-02-29

windows thinkpad android environment setup problem Chinese WORD version

This document mainly talks about the problems of setting up the Windows ThinkPad Android environment; I hope this document will help friends in need; interested friends can come and take a look.
Mobile terminal
2024-02-29

Detailed explanation of UML class diagram Chinese WORD version

This document mainly talks about the detailed explanation of UML class diagram; in the static mechanism of UML, class diagram is a key point. It is not only the core concern of designers, but also the core concern of implementers. Modeling tools also generate code primarily based on class diagrams. Class diagram occupies a very important position among the 9 diagrams of UML. I hope this document will help friends in need; interested friends can come and take a look.
Other manuals
2024-02-29

Popular Recommendations

php7.3.8 offline Chinese manual (official version)

php7.3.8 official Chinese manual (chm format)

PHP7.2 Chinese manual

PHP Chinese manual download|chm|mobile version|pdf

html5 Chinese manual (CHM version)

HTML5 Chinese manual download (CHM version)

php 5.6 Chinese manual

PHP 5.6 Chinese manual download

PHP7.2 manual (latest version)

php7.2 development manual download CHM version

MySQL 5.1 Reference Manual

MySQL 5.1 Reference Manual Download
database
2017-02-10

HTML Chinese Manual (CHM version)

HTML Chinese manual (CHM version) download

Linux command list

Linux command encyclopedia download

ThinkPHP5.0 Development Manual

ThinkPHP5.0 Chinese complete manual download

JavaScript Reference Manual

JavaScript complete reference manual download