Alexbootch писал(а):
ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENTnesco писал(а):
Я понял так, что null для поля с AUTOINCREMENT'ом означает приращение на один.[size=-2]------ Добавлено в 10:20
So why, with the decision that data typing was a bad idea, has SQLite implemented one column type that's different? The reason for an INTEGER PRIMARY KEY is to allow for the equivalent of an AUTOINCREMENT or IDENTITY column.
You can insert any 32-bit signed integer value into an INTEGER PRIMARY KEY column, or insert a NULL to tell SQLite to assign the value itself. Inserting a NULL will cause a value of one greater than the largest value already stored in that column to be used.
You can insert any 32-bit signed integer value into an INTEGER PRIMARY KEY column, or insert a NULL to tell SQLite to assign the value itself. Inserting a NULL will cause a value of one greater than the largest value already stored in that column to be used.
Поиск
Друзья
Администрация