primary-key Archives - Page 2 of 2

What is Hash and Range Primary Key?

I am not able to understand what Range / primary key is here in the docs on Working with Tables and Data in ...

May 19, 2022
0 Comments

difference between primary key and unique key

I’m using mysql database. I have a confusion between primary key and unique key. Please help me where should I create primary and ...

May 18, 2022
0 Comments

SQL Server add auto increment primary key to existing table

As the title, I have an existing table which is already populated with 150000 records. I have added an Id column (which is ...

May 17, 2022
0 Comments

What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

May 9, 2022
0 Comments

Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table? 12 Answers 12

May 6, 2022
0 Comments

What’s the Hi/Lo algorithm?

What’s the Hi/Lo algorithm? I’ve found this in the NHibernate documentation (it’s one method to generate unique keys, section 5.1.4.2), but I haven’t ...

May 4, 2022
0 Comments

Unable to update the EntitySet – because it has a DefiningQuery and no element exist

I am using Entity Framework 1 with .net 3.5. I am doing something simple like this: var roomDetails = context.Rooms.ToList(); foreach (var room ...

April 30, 2022
0 Comments

How to reset postgres’ primary key sequence when it falls out of sync?

I ran into the problem that my primary key sequence is not in sync with my table rows. That is, when I insert ...

April 29, 2022
0 Comments

Sqlite primary key on multiple columns

What is the syntax for specifying a primary key on more than 1 column in SQLITE ? 9 s 9 According to the ...

April 27, 2022
0 Comments

How can I do ‘insert if not exists’ in MySQL?

I started by googling and found the article How to write INSERT if NOT EXISTS queries in standard SQL which talks about mutex ...

April 16, 2022
0 Comments