All geek questions in one place

Why is auto_increment underlined?

I was wondering why auto_increment "spelled" with underline, since primary key not null and it is not?

Is it because auto_increment is the old syntax remainder or one?

+6
source share
2 answers

Keys can be either primary or foreign, columns can be either null (non) or non-null.

There is no alternative increment option for auto_ - so it makes sense to have it as one word.

+3
source

I would suggest, because it is actually a niladic function (e.g. CURRENT_TIMESTAMP from the SQL standard). Even if he has no parameters today, they may have them in the future, for example. for seeds and increments (in accordance with SQL Server IDENTITY ).

0
source

Source: https://habr.com/ru/post/911484/

More articles:


All Articles