Top "Primary-key" questions

A key is a set of attributes that is irreducibly unique and non-nullable within a table.

MySQL unique column string

Currently I have this table in my database: CREATE TABLE `twMCUserDB` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mc_userName` text …

mysql sql primary-key unique unique-key
Dapper insert into table that has a composite PK

I have a table that has a primary key composed of two columns, neither of which are auto-incrementing, and my …

c# primary-key dapper dapper-extensions
Primary key id reaching limit of bigint data type

I have a table that is exposed to large inserts and deletes on a regular basis (and because of this …

mysql int primary-key auto-increment bigint
Using Hibernate Get with Multi-Column Primary Key

Say I have a class that looks like this: public class MyClass { @Id @Column(name = "ID") private long Id; } I …

java hibernate primary-key composite-primary-key
MySQL Views in Navicat - How to define 'primary key'?

Often when I define a View in Navicat I receive the following message: xxx does not have a primary key. …

mysql views primary-key unique-index navicat
How to drop clustered property but retain primary key in a table. SQL Server 2005

i have the following key: ALTER TABLE dbo.Table ADD CONSTRAINT PK_ID PRIMARY KEY CLUSTERED ( ID ASC ) so i …

sql sql-server sql-server-2005 primary-key clustered-index
Slow INSERT into InnoDB table with random PRIMARY KEY column's value

For my website I use the PHP API for Flickr ( http://www.flickr.com/services/api/ ). This API provides several …

mysql primary-key innodb flickr
SQL Server AUTO_INCREMENT error

Interface: HeidiSQL Database: SQL Server I'm trying to create table keeping ID (int) column as primary key as well as …

database sql-server-2008 primary-key auto-increment heidisql
sql swap primary key values

is it possible to swap primary key values between two datasets? If so, how would one do that?

sql primary-key swap
Django + PostgreSQL: How to reset primary key?

I have been working on an application in Django. To begin with, for simplicity, I had been using sqlite3 for …

django database postgresql primary-key