Web Coding Center
SQL
Data Types
Data Types Numeric
Data Types String
Date and Time
Table Definitions
CREATE TABLE
Character Sets and Collations
ALTER TABLE
RENAME TABLE
TRUNCATE TABLE
DROP TABLE
Basic Data Management
INSERT
REPLACE
UPDATE
DELETE
Basic Data Retrieval
SELECT
JOIN
UNION
Index Hint
HANDLER
PHP Integration
Procedural Style
Object Oriented Style
Conventions of Functions
Connection Functions
Query Functions
Information Functions
The mysqli result class
Functions and Operators
Operators
Type Conversion
Comparison
Flow Control
Numeric
String
Date and Time
Encryption and Compression
Database Information
GROUP BY Aggregate
Miscellaneous
Information and Variables
Information
SHOW
INFORMATION SCHEMA
SET
Injection Attacks
Hacking Techniques
Validating Input
MySQL Prepared Statements
PHP Prepared Statements
PDO
Backup and Recovery
Physical Backups
Internal Commands
External Commands
Binary Logging
Views
Algorithms
Updatable Views
Indexes
INDEX
FOREIGN KEY
Subquery
Scalar Subquery
Column Subquery
Table Subquery
Automation
EVENT
TRIGGER
Compound Statements
PROCEDURE and FUNCTION
Compound Flow Control
Local Variables
Cursors
Conditions
Transactions and Locks
Transactions
PHP Transactions
Locks
Partitioning
Creation
Management
Selection
Replication
Setting Up
Using SSL
Replication with GTIDs
Statement based vs Row based
Administration
Administrations
Accounts
Privileges
Connections
Table Maintenance
Others
Storage Engines
InnoDB
MyISAM
MEMORY
CSV
ARCHIVE
BLACKHOLE
MERGE
FEDERATED
EXAMPLE
Earn a fixed interest of 16% annually by holding USDT. Join us to claim your USD25 bitcoin now!
Let experts and bots trade cryptos for you. Claim USD25 now!
MENU
Functions and Operators
To illustrate the use of various MySQL functions and operators, many examples in this section use the SELECT clause. You may use the functions and operators in some other clauses such as the WHERE clause and the HAVING clause.