OmniFabric Docs
OmniFabric
Home
Overview
OmniFabric Introduction
OmniFabric Feature List
OmniFabric Feature
Feature Overview
HTAP
Multi-Account
Scalability
Cost-Effective
High Availability
Timing
Streams
User-defined functions
MySQL Compatibility
OmniFabric vs Other Databases
OmniFabric vs OLTP
What's New
Getting Started
Basic SQL
Develop
Overview
Ecological Tools
BI Connection
FineBI Connection
Superset Connection
Yonghong Connection
Computing Engine
Flink
Spark
ETL
DataX
Seatunnel
Scheduling Tools
DolphinScheduler
Connect to OmniFabric
Overview
Java
JDBC
ORM
Python
Go
C#
Database Client Tools
Data Operations
Import Data
Overview
Insert
Update
Delete
Prepared Statements
Bulk Load
Export Data
Modump
Select Into Outfile
Read Data
Single Table
Multi-table Joins
Subqueries
Views
CTE
Window Functions
Distinct Data
Bitmap
Count Distinct
Schema Design
Overview
Create Database
Create Table
Create Table AS SELECT
Create Temporary Table
Create View
Create Secondary Index
Vector
Data Integrity
Overview
Primary Key
Foreign Key
Unique Key
Not Null
Auto Increment
Transactions
Overview
OmniFabric Transactions
Overview
Explicit
Implicit
How to Use
Isolation Level
MVCC
Optimistic
Pessimistic
Scenario
Vector
Vector Type
Vector Search
Cluster Centers
UDF
Python UDF
Python UDF Advanced
Publish-Subscribe
Overview
Multi-Account Overview
Performance Tuning
Performance Tuning Overview
Control Execution Plan
Optimizer Hints
Explain
Explain Overview
Explain Aggregation
Explain Joins
Explain Subqueries
Explain Views
Explain Walkthrough
Optimization Concepts
Through Partition Pruning
Through Cluster By
Through Partition By
Migrate
Overview
Migrate from MySQL
Migrate from Oracle
Migrate from SQL Server
Migrate from PostgreSQL
Reference
System Variables
System Variables Overview
System Variables parameters
SQL Mode
Save query result support
Timezone support
Lower case table names support
Foreign key checking support
User-specified case consistency support for query result set column names
Invalid Login Restrictions
Password complexity verification
Connection whitelist
Custom variables
SQL Language Structure
Keywords
Comments
Data Types
Data Types Overview
Data Type Conversion
Date and Time Types
Timestamp Initialization
YEAR Type
JSON Data Type
BLOB and TEXT Type
DATALINK Type
ENUM Type
UUID Type
Vector Type
Fixed-Point Types (Exact Value) - DECIMAL
SQL Statements
Type of SQL Statements
Data Definition Language
DDL Overview
CREATE DATABASE
CREATE INDEX
CREATE INDEX...USING IVFFLAT
CREATE FULLTEXT INDEX
CREATE TABLE
CREATE TABLE AS SELECT
CREATE TABLE ... LIKE
CREATE EXTERNAL TABLE
CREATE CLUSTER TABLE
CREATE DYNAMIC TABLE
CREATE FUNCTION (Python)
CREATE FUNCTION (SQL)
CREATE PITR
CREATE PUBLICATION
CREATE SEQUENCE
CREATE SNAPSHOT
CREATE SOURCE
CREATE STAGE
CREATE SUBSCRIPTION
CREATE VIEW
DROP DATABASE
DROP INDEX
DROP TABLE
DROP PITR
DROP PUBLICATION
DROP SEQUENCE
DROP STAGE
DROP SNAPSHOT
DROP VIEW
DROP FUNCTION
ALTER PITR
ALTER PUBLICATION
ALTER REINDEX
ALTER SEQUENCE
ALTER STAGE
ALTER TABLE
ALTER VIEW
TRUNCATE TABLE
RENAME TABLE
RESTORE PITR
RESTORE SNAPSHOT
Data Manipulation Language
INSERT
INSERT INTO SELECT
DELETE
UPDATE
LOAD DATA INFILE
LOAD DATA INLINE
CASE
REPLACE
UPSERT
Information Functions
Data Query Language
APPLY
JOIN
SELECT
SUBQUERY
With CTE
Combining Queries
Data Control Language
CREATE ACCOUNT
ALTER ACCOUNT
CREATE ROLE
CREATE USER
ALTER USER
DROP ACCOUNT
DROP USER
DROP ROLE
GRANT
REVOKE
Other
SHOW
SET
USE
KILL
Prepared Statements
Explain
Functions and Operators
Operators
Operators Overview
INTERVAL
OPERATORS
Functions
OmniFabric Function List
Aggregate Functions
Mathematical
String
Regular Expressions
Datetime
Table
Vector
Window Functions
JSON Functions
Other Functions
System OPS Functions
System Paramaters
System Parameters Overview
Standalone Common Parameters Configuration
Distributed Common Parameters Configuration
Configuration Settings
OmniFabric Catalog
MO Tools
mo_ctl
mo_ctl_standalone
mo_datax_writer
mo_ssb_open
mo_tpch_open
mo_ts_perf_test
Release Notes
Release Timeline
v25.2.1.0
v25.2.0.3
v25.2.0.2
v24.2.0.1
v24.2.0.0
v24.1.2.4
v24.1.2.3
v24.1.2.2
v24.1.2.1
v24.1.2.0
v24.1.1.3
v24.1.1.2
v24.1.1.1
Tutorial
C# .NET CRUD Demo
Develop Golang CRUD Demo
Develop Java CRUD Demo
Develop Python CRUD Demo
Django Python CRUD Demo
RAG Demo
SpringBoot Hibernate CRUD Demo
SpringBoot MyBatis CRUD Demo
SQLAlchemy Python CRUD Demo
Test
Testing Tool
MO Tester
Troubleshooting
Common Statistics Query
Error Code
Query Table Statistics
Slow Queries
Glossary
OmniFabric Docs
OmniFabric
Reference
Functions and Operators
Operators
OPERATORS
Logical Operators
Logical Operators Overview
Edit on cloudsigma/omnifabric-docs
Logical Operators
Name
Description
AND,&&
Logical AND
NOT,!
Negates value
OR
Logical OR
XOR
Logical XOR