Halo-Mysql部分兼容性测试

贾桂权 2024-06-11

109

MySQL 是当今最常用的关系型数据库管理系统之一，它在的应用领域非常广泛。羲和（Halo）数据库作为新一代高性能安全自主可控全场景通用型统一数据库，对Mysql的兼容能力也十分成熟，本文主要是简单的介绍一下羲和数据库（Halo）兼容Mysql的一些数据类型。

整数类型

INT

CREATE TABLE int_mytest (id INT,id_signed INT SIGNED,id_unsigned INT UNSIGNED);INSERT INTO int_mytest (id, id_signed, id_unsigned) VALUES (-123, -456, 789);SELECT * FROM int_mytest;

BIGINT

CREATE TABLE bigint_mytest (id BIGINT,id_signed BIGINT SIGNED,id_unsigned BIGINT UNSIGNED);INSERT INTO bigint_mytest (id, id_signed, id_unsigned) VALUES (-123456789, -987654321, 123456789);SELECT * FROM bigint_mytest;

TINYINT

CREATE TABLE tinyint_mytest (id TINYINT,id_signed TINYINT SIGNED,id_unsigned TINYINT UNSIGNED);INSERT INTO tinyint_mytest (id, id_signed, id_unsigned) VALUES (-123, -127, 255);SELECT * FROM tinyint_mytest;

SMALLINT

CREATE TABLE smallint_mytest (id SMALLINT,id_signed SMALLINT SIGNED,id_unsigned SMALLINT UNSIGNED);INSERT INTO smallint_mytest (id, id_signed, id_unsigned) VALUES (-12345, -32767, 65535);SELECT * FROM smallint_mytest;

MEDIUMINT

CREATE TABLE mediumint_mytest (id MEDIUMINT,id_signed MEDIUMINT SIGNED,id_unsigned MEDIUMINT UNSIGNED);INSERT INTO mediumint_mytest (id, id_signed, id_unsigned) VALUES (-123456, -8388607, 16777215);SELECT * FROM mediumint_mytest;

浮点类型

FLOAT

CREATE TABLE float_mytest (id FLOAT,id_unsigned FLOAT UNSIGNED);INSERT INTO float_mytest (id, id_unsigned) VALUES (-12.34, 56.78);SELECT * FROM float_mytest;

DOUBLE

CREATE TABLE double_mytest (id DOUBLE,id_unsigned DOUBLE UNSIGNED);INSERT INTO double_mytest (id, id_unsigned) VALUES (-12.34, 56.78);SELECT * FROM double_mytest;

NUMERIC

CREATE TABLE numeric_mytest (id NUMERIC(10, 2),id_unsigned NUMERIC(10, 2) UNSIGNED);INSERT INTO numeric_mytest (id, id_unsigned) VALUES (-12.34, 56.78);SELECT * FROM numeric_mytest;

字符类型

CHAR

CREATE TABLE char_mytest (id INT,char_value CHAR(10));INSERT INTO char_mytest (id, char_value) VALUES (1, 'Hello');SELECT * FROM char_mytest;

VARCHAR

CREATE TABLE varchar_mytest (id INT,varchar_value VARCHAR(50));INSERT INTO varchar_mytest (id, varchar_value) VALUES (1, 'Hello');SELECT * FROM varchar_mytest;

TEXT

CREATE TABLE text_mytest (id INT,text_value TEXT);INSERT INTO text_mytest (id, text_value) VALUES (1, 'This is a text');SELECT * FROM text_mytest;

MEDIUMTEXT

CREATE TABLE mediumtext_mytest (id INT,mediumtext_value MEDIUMTEXT);INSERT INTO mediumtext_mytest (id, mediumtext_value) VALUES (1, 'This is a medium-sized text');SELECT * FROM mediumtext_mytest;

LONGTEXT

CREATE TABLE longtext_mytest (id INT,longtext_value LONGTEXT);INSERT INTO longtext_mytest (id, longtext_value) VALUES (1, 'This is a long text');SELECT * FROM longtext_mytest;

TINYTEXT

CREATE TABLE tinytext_mytest (id INT,tinytext_value TINYTEXT);INSERT INTO tinytext_mytest (id, tinytext_value) VALUES (1, 'Tiny text');SELECT * FROM tinytext_mytest;

日期类型

DATE

CREATE TABLE date_mytest (id INT,date_value DATE);INSERT INTO date_mytest (id, date_value) VALUES (1, '2022-01-01');SELECT * FROM date_mytest;

TIME

CREATE TABLE time_mytest (id INT,time_value TIME);INSERT INTO time_mytest (id, time_value) VALUES (1, '10:30:00');SELECT * FROM time_mytest;

DATETIME

CREATE TABLE datetime_mytest (id INT,datetime_value DATETIME);INSERT INTO datetime_mytest (id, datetime_value) VALUES (1, '2022-01-01 10:30:00');SELECT * FROM datetime_mytest;

TIMESTAMP

CREATE TABLE timestamp_mytest (id INT,timestamp_value TIMESTAMP);INSERT INTO timestamp_mytest (id, timestamp_value) VALUES (1, '2022-01-01 10:30:00');SELECT * FROM timestamp_mytest;

YEAR

CREATE TABLE year_mytest (id INT,year_value YEAR);INSERT INTO year_mytest (id, year_value) VALUES (1, 2022);SELECT * FROM year_mytest;

今天简单的分享到这里，如果您对数据库感兴趣，请留言+关注，谢谢~

halo 数据库国产数据库集中式数据库关系型数据库

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

Halo-Mysql部分兼容性测试

评论