What if int PK is 0?

B

BonBon Slick2019-02-16 12:21:04

Database

BonBon Slick, 2019-02-16 12:21:04

It never even occurred to me to sculpt 0 as the ID of the first record.
What happens if you put 0 as the ID for the first entry?
Possible mistakes?
Why does auto inc int PK start at 1?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Melkij, 2019-02-16
@BonBonSlick

Yes, at least start with INT_MIN, it doesn't matter for the counter to tick from 0, from 1, or from -2147483648.
One is just the default start value in most implementations (I'm not aware of examples of this, but they are possible).

Similar questions

I

iDimasRus2014-02-22 15:42:44

What is the program for the ordered storage of information about physical. faces aka dossier? 0Reply

T

Think With Your Head2016-04-27 10:56:58

How to update the database of online store products, the attributes of which are transferred from 1s and can be changed in the site admin panel? 1Reply

B

berapru2016-04-27 14:40:35

How to conveniently update/load data into a MYSQL table? 1Reply

A

AnatolyBossman2020-08-20 11:18:06

What you need to know before learning the database? 1Reply

G

Gudsaf2016-04-29 01:08:29

Would you criticize the logic of my Warehouse database for MySQL (screenshots and MySQLWrkBnch model under the cut)? 2Reply

Didn't find what you were looking for?

Ask your question