Home Tutorial Php Sql MySQL BIGINT

 
 

MySQL BIGINT
Posted on: December 9, 2010 at 12:00 AM
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 |
+----------------------+

 

Related Tags for MySQL BIGINT:


Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.