MySQL BIGINT


 

MySQL BIGINT

This example illustrates how to use the bigint data type in the MySQL query

This example illustrates how to use the bigint data type in the MySQL query

MySQL BIGINT

This example illustrates how to use the bigint data type in the MySQL query.

In this example we create a table with column bigint data type.

 

Query

 

create table table1 (col1 bigint default -9223372036854775807);

 

Query

 

insert into table1 values (default);

 

Query

 

select * from table1;

 

Output

 

+----------------------+
| col1                 |
+----------------------+
| -9223372036854775807 |
+----------------------+

 

Ads