Skip to main content

Integer Types

WormSQL supports the following integer data types:

  • INT8: 8-bit signed integer
  • INT16: 16-bit signed integer
  • INT32: 32-bit signed integer
  • INT or INTEGER: 64-bit signed integer (default)
  • INT128: 128-bit signed integer
  • UINT8: 8-bit unsigned integer
  • UINT16: 16-bit unsigned integer
  • UINT32: 32-bit unsigned integer
  • UINT64: 64-bit unsigned integer
  • UINT128: 128-bit unsigned integer

For general purposes, you can use INTEGER to specify a 64-bit signed integer.

Here's an example of how to create a table with integer data types:

SELECT * Item (
  field_one INTEGER,
  field_two INTEGER
);

You can insert data into the Item table as follows:

INSERT INTO Item VALUES (1, -1), (-2, 2), (3, 3), (-4, -4);

You can perform arithmetic operations such as addition, subtraction, multiplication, division, and modulo on integer columns. Note that if you perform arithmetic operations on columns with different integer types, WormSQL will automatically convert the types of the operands to match the type of the left-hand operand. For example, if you perform UINT8 + INT64, WormSQL will convert the INT64 operand to UINT8 and then perform the addition.

Integer types are an important part of SQL, and you can use them to store data ranging from small whole numbers to large integers. By understanding how to use integer types in your database, you can write efficient and effective SQL queries that work with a wide range of data.