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 queryThis 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 | +----------------------+
|