tagged [primary-key]
Can I use VARCHAR as the PRIMARY KEY?
Can I use VARCHAR as the PRIMARY KEY? I have a table for storing coupons/discounts, and I want to use the coupon_code column as the primary key, which is a `VARCHAR`. My rationale is that, each coupon...
- Modified
- 18 May at 12:38
Strings as Primary Keys in MYSQL Database
Strings as Primary Keys in MYSQL Database I am not very familiar with databases and the theories behind how they work. Is it any slower from a performance standpoint (inserting/updating/querying) to u...
- Modified
- 16 Feb at 11:0
Updating MySQL primary key
Updating MySQL primary key I have a table `user_interactions` with 4 columns: The primary key is `(user_1,user_2,type)` and I want to change to `(user_2,user_1,type)` So what I did was : and voila.....
- Modified
- 20 May at 20:25
Unable to update the EntitySet - because it has a DefiningQuery and no <UpdateFunction> element exist
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: I am getting this error when I ...
- Modified
- 5 Dec at 12:7
ServiceStack: OrmLite and generic Insert<T> method returns weird number - not the PrimaryKey or any auto_increment
ServiceStack: OrmLite and generic Insert method returns weird number - not the PrimaryKey or any auto_increment I have this POCO that I am adding to a db: ``` public class MyObject { [ServiceStack.D...
- Modified
- 9 Dec at 15:3
servicestack.net ormlite with sqlite - prevent automatic primary key on create table
servicestack.net ormlite with sqlite - prevent automatic primary key on create table How do you stop ServiceStack.Net OrmLite from automatically making a primary key column? My model is as follows: Wh...
- Modified
- 30 Mar at 06:24
Remove Primary Key in MySQL
Remove Primary Key in MySQL I have the following table schema which maps user_customers to permissions on a live MySQL database: ``` mysql> describe user_customer_permission; +------------------+-----...
- Modified
- 15 Mar at 22:18
How can I do 'insert if not exists' in MySQL?
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](http://www.xaprb.com/blog/2005/09/25/insert-if-not...
- Modified
- 10 May at 10:11
Why would servicestack ormlite save valid Guid values as NULL to SqLite database?
Why would servicestack ormlite save valid Guid values as NULL to SqLite database? I am having this problem intermittently with ServiceStack.Net OrmLite on SqLite. My model class is using a Guid for th...
- Modified
- 30 Mar at 14:46
Create view with primary key?
Create view with primary key? I create a view with following codes ``` SELECT CONVERT(NVARCHAR, YEAR(okuma_tarihi)) + 'T1' AS sno, YEAR(okuma_tarihi) AS Yillar, SUM(toplam_kullanim_T1) AS TotalU...
- Modified
- 16 Sep at 00:13
Create association on non-primary key fields with Entity Framework 4.1 Fluent API
Create association on non-primary key fields with Entity Framework 4.1 Fluent API We are using EF 4.1 and the fluent API to get data from a legacy database (that we are not permitted to change). We ar...
- Modified
- 1 Nov at 13:57
Dapper insert into table that has a composite PK
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 Dapper insert (part of Dapper Extensions)...
- Modified
- 17 Mar at 19:46
MySQL: #1075 - Incorrect table definition; autoincrement vs another key?
MySQL: #1075 - Incorrect table definition; autoincrement vs another key? Here is a table in MySQL 5.3.X+ db: ``` CREATE TABLE members` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `memberid` VAR...
- Modified
- 13 Nov at 20:45
Auto Increment after delete in MySQL
Auto Increment after delete in MySQL I have a MySQL table with a primary key field that has AUTO_INCREMENT on. After reading other posts on here I've noticed people with the same problem and with vari...
- Modified
- 16 Jul at 12:10
MySQL duplicate entry error even though there is no duplicate entry
MySQL duplicate entry error even though there is no duplicate entry I am using MySQL 5.1.56, MyISAM. My table looks like this: ``` CREATE TABLE IF NOT EXISTS `my_table` ( `number` int(11) NOT NULL, ...
- Modified
- 30 Oct at 04:32
Number VS Varchar(2) Primary Keys
Number VS Varchar(2) Primary Keys I'm now to this point of my project that I need to design my database (Oracle). Usually for the status and countries tables I don’t use a numeric primary key, for exa...
- Modified
- 20 May at 20:33
Entity Framework 4: How to find the primary key?
Entity Framework 4: How to find the primary key? I am trying to create a generic method using EF4 to find the primary key of an object. example To give more info I am working off of the Tekpub Starter...
- Modified
- 7 Dec at 06:11
How to retrieve the last autoincremented ID from a SQLite table?
How to retrieve the last autoincremented ID from a SQLite table? I have a table Messages with columns ID (primary key, autoincrement) and Content (text). I have a table Users with columns username (pr...
- Modified
- 28 Aug at 22:2
"Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF" with composite key
"Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF" with composite key We have recently added a new "level" to our database - added a key "Company_ID" to be ...
- Modified
- 22 May at 14:15
Understanding ForeignKey attribute in entity framework code first
Understanding ForeignKey attribute in entity framework code first See the following post for some background: [Entity framework one to zero or one relationship without navigation property](https://sta...
- Modified
- 26 Sep at 14:17