Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

What is the difference between int and integer in MySQL 5.0?

Tags:

types

integer

mysql

What is the difference between int and integer datatypes in MySQL 5.0? Can anyone help? I don't understand the exact difference.

like image 859
sivakumar Avatar asked Mar 27 '09 04:03

sivakumar

People also ask

Is int and integer same in MySQL?

MySQL supports the SQL standard integer types INTEGER (or INT ) and SMALLINT . As an extension to the standard, MySQL also supports the integer types TINYINT , MEDIUMINT , and BIGINT . The following table shows the required storage and range for each integer type.

What is the difference between an integer and int?

A int is a data type that stores 32 bit signed two's compliment integer. On other hand Integer is a wrapper class which wraps a primitive type int into an object. int helps in storing integer value into memory. Integer helps in converting int into object and to convert an object into int as per requirement.

What does Int 5 mean in MySQL?

In MySQL, INT(5) does not mean that values are limited to 5-character values. It only means that MySQL will try to pad these values with spaces/zeroes when returning them. The numeric range of any signed INT including INT(10), INT(5) or any other INT(n) is: -2,147,483,648 ... 2,147,483,647, which is 10 digits at most.

What is integer in MySQL?

In MySQL, INTEGER (INT) is a numeric value without a decimal. It defines whole numbers that can be stored in a field or column. In addition, MySQL supports the display_width attribute (for example, INT(1)) and the ZEROFILL attribute, which automatically adds zeros to the value depending on the display width.

2 Answers

Taken from MYSQL 5.0 online reference

The keyword INT is a synonym for INTEGER.

like image 82
TechTravelThink Avatar answered Oct 01 '22 05:10

TechTravelThink

I guess the only difference is the spelling.

So by using INT, you'd end up using less bytes on your SQL script (not that it matters).

like image 26
ksuralta Avatar answered Oct 01 '22 06:10

ksuralta
Sign in to Comment

Related questions

ON DUPLICATE KEY + AUTO INCREMENT issue mysql
What happens if I drop a MySQL column without dropping its index first?
golang gorm Access the underlying mysql query
How do I lock read/write to MySQL tables so that I can select and then insert without other programs reading/writing to the database?
How can I avoid getting this MySQL error Incorrect column specifier for column COLUMN NAME?
Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
MySQL too long varchar truncation/error setting
How to replace/remove 4(+)-byte characters from a UTF-8 string in PHP?
ORDER BY ASC with Nulls at the Bottom
mysql error: Table "mysql"."innodb_table_stats" not found
SQL search multiple values in same field
Using Jquery Ajax to retrieve data from Mysql
How to get size of column in mysql table
How can I use SQL's YEAR(), MONTH() and DAY() in Doctrine2?
Is MySQL Temporary table a shared resource?
MySQL query - using SUM of COUNT
MySQL varchar index length
MySQL: SELECT UNIQUE VALUE
check for duplicate entry vs use PDO errorInfo result
Enable Python to Connect to MySQL via SSH Tunnelling

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!