Question : I’m working with application that can have millions of data. Just wondering if it is ok to use […]
serial field issue
Question : Q: I use a serial as a datatype for my primary keys in my tables. I insert a […]
MySQL – Set trigger BEFORE INSERT for new ID is safe?
Question : How to create customize primary key in MySQL?, example i have table and the table name is X, […]
make MariaDB Auto-Increment-Increment dynamic
Question : In a certain replication setup I have created multi-master replication in STAR topology using MariaDB. I have an […]
Do I need an auto-generated ID in addition to a unique field?
Question : I have a table that represents a list of currencies. Here is a simplified version of it: CREATE […]
Reasons for avoiding large ID values
Question : We are working on a web application, not yet accessible to users. My boss noticed that newly created […]
Identity column re-seed: when it is necessary?
Question : During one of the last lessons at university (I’m a student), lecturer asked us to develop a database […]
Moving data from one database to another database with auto incriment keys
Question : I have table1, table2 and table3, all of them have a primary serial key id (or think of […]
MySQL – Autoincrement does not increment sequentally if last row was deleted
Question : I have a table which contains an auto incremented primary key id. If I delete the last row […]
Getting duplicate primary key for auto increment column
Question : I have a MySQL Innodb table with ‘id’ as auto increment primary key column. My Scripts are doing […]