Data Types

MatrixOne Data types conforms with MySQL Data types definition.

Reference: <https://dev.mysql.com/doc/refman/8.0/en/data-types.html>

Integer Numbers

Real Numbers

String Types

Time and Date Types

Examples

1. //Create a table named "numtable" with 3 attributes of an "int", a "float" and a "double"
2. > create table numtable(id int,fl float, dl double);

4. //Insert a dataset of int, float and double into table "numtable"
5. > insert into numtable values(3,1.234567,1.2345678912345678912);

7. // Create a table named "numtable" with 2 attributes of an "int" and a "float" up to 5 digits in total, of which 3 digits may be after the decimal point.
8. > create table numtable(id int,fl float(5,3));

10. //Insert a dataset of int, float into table "numtable"
11. > insert into numtable values(3,99.123);

13. //Create a table named "numtable" with 2 attributes of an "int" and a "float" up to 23 digits in total.
14. > create table numtable(id int,fl float(23));

16. //Insert a dataset of int, float into table "numtable"
17. > insert into numtable values(1,1.2345678901234567890123456789);

19. //Create a table named "numtable" with 4 attributes of an "unsigned tinyint", an "unsigned smallint", an "unsigned int" and an "unsigned bigint"
20. > create table numtable(a tinyint unsigned, b smallint unsigned, c int unsigned, d bigint unsigned);

22. //Insert a dataset of unsigned (tinyint, smallint, int and bigint) into table "numtable"
23. > insert into numtable values(255,65535,4294967295,18446744073709551615);

25. //Create a table named "names" with 2 attributes of a "varchar" and a "char"
26. > create table names(name varchar(255),age char(255));

28. //Insert a data of "varchar" and "char" into table "names"
29. > insert into names(name, age) values('Abby', '24');

31. //Create a table named "calendar" with 2 attributes of a "date" and a "datetime"
32. > create table calendar(a date, b datetime);

34. //Insert a data of "date" and "datetime" into table "calendar"
35. > insert into calendar(a, b) values('20220202, '2022-02-02 00:10:30');
36. > insert into calendar(a, b) values('2022-02-02, '2022-02-02 00:10:30');