AUTO_INCREMENT in MySQL can be signed by default?

MySQL Database Training for Beginners

39 Lectures 5.5 hours

Simon Sez IT

More Detail

Python programming with MySQL database: from Scratch

152 Lectures 16 hours

Metla Sudha Sekhar

More Detail

Learn MySQL from scratch for Data Science and Analytics

87 Lectures 5.5 hours

Metla Sudha Sekhar

More Detail

Yes, the AUTO_INCREMENT in MySQL will be signed (Positive and Negative Value both) by default.

Let us first create a table −

mysql> create table DemoTable
   -> (
   -> MyNumber int AUTO_INCREMENT PRIMARY KEY
   -> );
Query OK, 0 rows affected (0.45 sec)

Insert some records in the table using insert command. Here, we have set negative values as well for AUTO_INCREMENT column −

mysql> insert into DemoTable values() ;
Query OK, 1 row affected (0.19 sec)

mysql> insert into DemoTable values(-100);
Query OK, 1 row affected (0.12 sec)

mysql> insert into DemoTable values(-300);
Query OK, 1 row affected (0.13 sec)

mysql> insert into DemoTable values(0);
Query OK, 1 row affected (0.18 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable;

Output

+----------+
| MyNumber |
+----------+
|   -300   |
|   -100   |
|      1   |
|      2   |
+----------+
4 rows in set (0.00 sec)

Rama Giri

Updated on 30-Jul-2019 22:30:26

• Related Questions & Answers
• Change the Auto Increment counter in MySQL?
• Passing NULL to MySQL for auto increment?
• How to change auto increment number in MySQL?
• Set custom Auto Increment with ZEROFILL in MySQL
• Set MySQL int column to auto increment by 1 beginning at 10000?
• Set the MySQL primary keys auto increment to be unlimited (or incredibly huge)?
• How can I set my auto-increment value to begin from 1 in MySQL?
• How to make MySQL table primary key auto increment?
• Two columns as primary key with auto-increment in MySQL?
• How to get the next auto-increment id in MySQL?
• How to set initial value and auto increment in MySQL?
• MySQL query to set my auto increment column ( id ) to zero or reset the value of auto increment field?
• What if I forgot to set Auto Increment? Can I set it later in MySQL?
• How to change auto increment number in the beginning in MySQL?
• Changing the current count of an Auto Increment value in MySQL?