×
思维导图备注
MatrixOne v0.5.1 Documentation
首页
白天
夜间
小程序
阅读
书签
我的书签
添加书签
移除书签
Data Types
Github
来源:MatrixOne
浏览
91
扫码
分享
2023-07-17 22:24:44
Date Types Overview
Data Type Conversion
Fixed-Point Types (Exact Value) - DECIMAL
当前内容版权归
MatrixOne
或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问
MatrixOne
.
上一篇:
下一篇:
版本
MatrixOne v1.1 中文文档
MatrixOne v1.1 Documentation
MatrixOne v1.0 中文文档
MatrixOne v0.8.0 中文文档
MatrixOne v0.8.0 Documentation
MatrixOne v0.7.0 Documentation
MatrixOne v0.7.0 中文文档
MatrixOne v0.6.0 Documentation
MatrixOne v0.6.0 中文文档
MatrixOne v0.5.1 Documentation
MatrixOne v0.4 中文文档
MatrixOne v0.4 Documentation
MatrixOne v0.3 中文文档
MatrixOne v0.3 Documentation
MatrixOne
Home
Overview
MatrixOne Introduction
MatrixOne Architecture
What’s New
Getting Started
Install Standalone MatrixOne
Connect to MatrixOne Server
Developing Guide
Connect to MatrixOne
Using client connect to the MatrixOne
Using Java connect to the MatrixOne
Using Python connect to the MatrixOne
Import Data
Import Data
Export Data
Export data
Example Application
Build a simple Java CRUD demo with MatrixOne
Python stock analysis Demo
Maintenance
Upgrade Standalone MatrixOne
Migration
Migrate data from MySQL to MatrixOne
Testing
Performance Testing
SSB Test with MatrixOne
TPCH Test with MatrixOne
Testing Tool
MO-Tester
Reference
SQL Reference
DDL
CREATE DATABASE
CREATE TABLE
DROP DATABASE
DROP TABLE
PRIMARY KEY
DML
INSERT
INSERT INTO SELECT
UPDATE
DELETE
LOAD DATA
SELECT
SHOW DATABASES
SHOW TABLES
USE
INTERVAL
With CTE
SUBQUERY
SUBQUERY Overview
Derived Tables
Comparisons Using Subqueries
SUBQUERY with ANY or SOME
SUBQUERY with ALL
SUBQUERY with EXISTS
SUBQUERY with IN
JOIN
JOIN Overview
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOIN
NATURAL JOIN
OPERATORS
OPERATORS Overview
OPERATORS Precedence
Arithmetic Operators
Arithmetic Operators Overview
%,MOD
*
+
-
-
/
DIV
Assignment Operators
Assignment Operators Overview
\=
Cast Functions and Operators
Cast Functions and Operators Overview
CAST
CONVERT
Comparison Functions and Operators
Comparison Functions and Operators Overview
>
>=
<
<>,!=
<=
\=
BETWEEN … AND …
IN
IS
IS NOT
IS NOT NULL
IS NULL
LIKE
NOT BETWEEN … AND …
NOT LIKE
Flow Control Functions
Flow Control Functions Overview
CASE WHEN
IF
Logical Operators
Logical Operators Overview
AND,&&
NOT,!
OR
XOR
Aggregate Functions
AVG
COUNT
MAX
MIN
SUM
ANY_VALUE
BIT_AND
BIT_OR
BIT_XOR
STDDEV_POP
VAR
Transactions
Transaction Overview
Explain
EXPLAIN
EXPLAIN Output Format
Data Types
Date Types Overview
Data Type Conversion
Fixed-Point Types (Exact Value) - DECIMAL
Builtin Functions
Mathematical
ABS()
SIN()
COS()
TAN()
COT()
ACOS()
ATAN()
SINH()
FLOOR()
ROUND()
CEIL()
POWER()
PI()
LOG()
LN()
EXP()
Datetime
YEAR()
MONTH()
DATE()
WEEKDAY()
DAYOFYEAR()
EXTRACT()
DATE_ADD()
DATE_SUB()
TO_DATE()
UNIX_TIMESTAMP
FROM_UNIXTIME
UTC_TIMESTAMP()
String
CONCAT_WS()
FIND_IN_SET()
OCT()
EMPTY()
LENGTH()
CHAR_LENGTH()
LTRIM()
RTRIM()
LPAD()
RPAD()
STARTSWITH()
ENDSWITH()
SUBSTRING()
SPACE()
REVERSE()
System Paramaters
General Settings
MySQL Compatibility
MatrixOne Catalog
FAQs
Product FAQs
Deployment FAQs
SQL FAQs
Release Notes
Release Timeline
v0.5.1
v0.5.0
v0.4.0
v0.3.0
v0.2.0
v0.1.0
Glossary
Contribution Guide
Make Your First Contribution
How to Contribute
Types of Contributions
Preparation
Report an Issue
Contribute Code
Review a Pull Request
Contribute Documentation
Make a Design
Code Style
Code of Conduct
Code Comment Style
Commit & Pull Request Style
暂无相关搜索结果!
本文档使用
BookStack
构建
×
分享,让知识传承更久远
×
文章二维码
手机扫一扫,轻松掌上读
×
文档下载
普通下载
下载码下载(免登录无限下载)
你与大神的距离,只差一个APP
请下载您需要的格式的文档,随时随地,享受汲取知识的乐趣!
PDF
文档
EPUB
文档
MOBI
文档
温馨提示
每天每在网站阅读学习一分钟时长可下载一本电子书,每天连续签到可增加阅读时长
下载码方式下载:免费、免登录、无限制。
免费获取下载码
下载码
文档格式
PDF
EPUB
MOBI
码上下载
×
微信小程序阅读
您与他人的薪资差距,只差一个随时随地学习的小程序
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度