How can I define a column as 64bit integer using SQL

Question

I'm creating a table as following:

create table SomeTable (
LoginTime int,
someValue 64bit-int
)

How can I define the second column as 64bit integer?

Solution 1

In MySQL, the BIGINT datatype represents an 8 byte (64-bit) integer. It can be SIGNED or UNSIGNED which permits (or prevents) negative numbers in the column.

You can read more about all variants of MySQL integer data types here. The column attributes are discussed here.

Solution 2

I assume you are using Sql Server. You want to use a

bigint - signed 64-bit.

Comments

[marc_s]

What database system, and which version?? SQL is just the Structured Query Language - a language used by many database systems - SQL is NOT a database product... stuff like this is very often vendor-specific - so we really need to know what database system you're using....

[speedmancs]

i'm using mysql indeed, is bigint ok for mysql?

[Valamas]

Yes (10 more characters to go)

[milahu]

BIGINT UNSIGNED or BIGINT SIGNED