What is the difference between int and integer in MySQL?

Environment: MySQLSever5.1 question: What is the difference between int and integer in MySQL? Answer: No Difference Analysis: · INT [(M)] [UNSIGNED] [ZEROFILL] an integer of the normal size. The signed range is-2147483648 to 2147483647. The unsigned range is 0 to 4294967295. · INTEGER [(M)] [UNSIGNED] [ZEROFILL] This is

Environment: MySQLSever 5.1 question: What is the difference between int and integer in MySQL? Answer: No Difference Analysis: · INT [(M)] [UNSIGNED] [ZEROFILL] an integer of the normal size. The signed range is-2147483648 to 2147483647. The unsigned range is 0 to 4294967295. · INTEGER [(M)] [UNSIGNED] [ZEROFILL] This is

Stage: MySQLSever 5.1

Question: What is the difference between int and integer in MySQL?

Answer: No difference

Analysis:

· INT [(M)] [UNSIGNED] [ZEROFILL]

An integer of the normal size. The signed range is-2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

· INTEGER [(M)] [UNSIGNED] [ZEROFILL]

This is a synonym for INT. There is no essential difference between the two names for simplicity and convenience.

References: http://zhidao.baidu.com/question/96012112