Top "Bigint" questions

mysql alter int column to bigint with foreign keys

I want to change the datatype of some primary-key columns in my database from INT to BIGINT. The following definition …

mysql foreign-keys int alter bigint

How does Rust's 128-bit integer `i128` work on a 64-bit system?

Rust has 128-bit integers, these are denoted with the data type i128 (and u128 for unsigned ints): let a: i128 = 170141183460469231731687303715884105727; …

rust x86-64 bigint int128 llvm-codegen

Convert a bigint to a string in Go

How do one convert a big int to a string (or integer) in Golang? bigint := big.NewInt(123) //This is what …

string int go bigint

Assembly multiplication of 16-bit x 32-bit => 48-bit

Assume I want to multiply a large number by another (maybe small) number in assembly. The big number (multiplicand) is …

assembly x86-16 bigint extended-precision

Converting bigint to timestamp in presto

I have a column in my dataset that has a datatype of bigint: Col1 Col2 1 1519778444938790 2 1520563808877450 3 1519880608427160 4 1520319586578960 5 1519999133096120 How do I convert Col2 …

date time timestamp bigint presto

SQL Server POWER function

Using SQL Server 2008 R2 when I enter the following query: SELECT CAST(POWER(2.0, 63.0) AS BIGINT); Which yields the result: 9223372036854775800 However, …

sql sql-server sql-server-2008-r2 bigint

Rails Migration: Bigint on PostgreSQL seems to be failing?

Trying to create a table with a bigint column creates a standard integer column instead. What could be going wrong? …

ruby-on-rails postgresql activerecord migration bigint

Can T-SQL store ulong's?

I want to store a C#.NET ulong into a T-SQL database. I don't see any provisions for doing this, …

c# .net sql bigint ulong

Convert binary string to bigint in MySQL?

I am attempting to hash a string to a 64-bit value (bigint) in MySQL. I am aware of the MD5() …

mysql hash binary md5 bigint

Primary key id reaching limit of bigint data type

I have a table that is exposed to large inserts and deletes on a regular basis (and because of this …

mysql int primary-key auto-increment bigint