mysql
  1. mysql-int
PreviousNext

INT - (MySQL Misc)

INT is a data type in MySQL that is used to store integers. In this tutorial, we'll discuss some of the miscellaneous features of the INT data type in MySQL.

Syntax

The syntax for defining an INT column in MySQL is as follows:

column_name INT[(length)] [UNSIGNED] [ZEROFILL] [NOT NULL] [AUTO_INCREMENT]
  • length: The number of digits that can be stored in the column. The default value is 11.
  • UNSIGNED: Specifies that the column can only contain positive integers.
  • ZEROFILL: Pads the column value with zeros until it reaches the specified length.
  • NOT NULL: Specifies that the column cannot contain NULL values.
  • AUTO_INCREMENT: Numbers the column automatically with a unique value for each new row.

Example

Let's create a table called "employees" with an "id" column that uses the INT data type with the AUTO_INCREMENT and UNSIGNED attributes.

CREATE TABLE employees (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  first_name VARCHAR(30) NOT NULL,
  last_name VARCHAR(30) NOT NULL,
  PRIMARY KEY (id)
);

Now, let's insert a row into the table without specifying a value for the "id" column:

INSERT INTO employees (first_name, last_name) VALUES ('John', 'Doe');

MySQL will automatically generate a value for the "id" column:

id first_name last_name
1 John Doe

Output

When we run the example code above, the output will be an empty result set:

Query OK, 1 row affected

This indicates that one row was successfully inserted into the "employees" table.

Explanation

In the example above, we used the INT data type to define an "id" column in the "employees" table. We also included the AUTO_INCREMENT and UNSIGNED attributes to automatically number the column and ensure that it only contains positive integers. When we inserted a row into the table without specifying a value for the "id" column, MySQL automatically generated a unique value for us.

Use

The INT data type in MySQL is useful for storing integer values such as IDs, counts, and ratings. The AUTO_INCREMENT attribute allows you to automatically number the column, making it easy to generate unique values for each new row.

Important Points

  • The INT data type in MySQL is used to store integer values.
  • The UNSIGNED attribute specifies that the column can only contain positive integers.
  • The ZEROFILL attribute pads the column value with zeros until it reaches the specified length.
  • The NOT NULL attribute specifies that the column cannot contain NULL values.
  • The AUTO_INCREMENT attribute numbers the column automatically with a unique value for each new row.

Summary

In this tutorial, we discussed some of the miscellaneous features of the INT data type in MySQL. We covered the syntax, example, output, explanation, use, and important points of the INT data type in MySQL. With this knowledge, you can now use the INT data type to store integer values in your MySQL database, and take advantage of features such as AUTO_INCREMENT to generate unique values for each new row.

ROLLUPToday
Published on: