tagged [unique]

Unique Key constraints for multiple columns in Entity Framework

Unique Key constraints for multiple columns in Entity Framework I'm using Entity Framework 5.0 Code First; I want to make the combination between `FirstColumn` and `SecondColumn`

How to sort and remove duplicates from Python list?

How to sort and remove duplicates from Python list? Given a list of strings, I want to sort it alphabetically and remove duplicates. I know I can do this: but I don't know how to retrieve the list mem...

3 May at 07:54

Count number of occurences for each unique value

Count number of occurences for each unique value Let's say I have: Now, I want to count the number of times each unique value appears. `unique(v)` returns what the unique values are, but not how many ...

17 Jun at 10:40

Mysql: Select rows from a table that are not in another

Mysql: Select rows from a table that are not in another How to select all rows in one table that do not appear on another? Table1: ``` +-----------+----------+------------+ | FirstName | LastName | Bi...

9 Dec at 23:53

Remove duplicate values from JS array

Remove duplicate values from JS array I have a very simple JavaScript array that may or may not contain duplicates. I need to remove the duplicates and put the unique values in a new array. I could po...

Unique, numeric, incremental identifier

Unique, numeric, incremental identifier I need to generate unique, incremental, numeric transaction id's for each request I make to a certain XML RPC. These numbers only need to be unique across my do...

13 Mar at 15:41

How to check if a table contains an element in Lua?

How to check if a table contains an element in Lua? Is there a method for checking if a table contains a value ? I have my own (naive) function, but I was wondering if something "official" exists for ...

20 Apr at 09:33

Generate N random and unique numbers within a range

Generate N random and unique numbers within a range What is an efficient way of generating N unique numbers within a given range using C#? For example, generate 6 unique numbers between 1 and 50. A la...

28 Nov at 21:19

How can I create a unique constraint on my column (SQL Server 2008 R2)?

How can I create a unique constraint on my column (SQL Server 2008 R2)? I have SQL Server 2008 R2 and I want to set a unique column. There seems to be two ways to do this: "unique index" and "unique ...

In Postgresql, force unique on combination of two columns

In Postgresql, force unique on combination of two columns I would like to set up a table in PostgreSQL such that two columns together must be unique. There can be multiple values of either value, so l...

1 Dec at 18:25

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...

18 May at 12:38

Generating random, unique values C#

Generating random, unique values C# I've searched for a while and been struggling to find this, I'm trying to generate several random, unique numbers is C#. I'm using `System.Random`, and I'm using a ...

21 Feb at 14:15

Can I add a UNIQUE constraint to a PostgreSQL table, after it's already created?

Can I add a UNIQUE constraint to a PostgreSQL table, after it's already created? I have the following table: ``` tickername | tickerbbname | tickertype ------------+---------------+------------ USDZAR...

INSERT ... ON DUPLICATE KEY (do nothing)

INSERT ... ON DUPLICATE KEY (do nothing) I have a table with a unique key for two columns: ``` CREATE TABLE `xpo`.`user_permanent_gift` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `fb_user_id` INT U...

27 Dec at 15:48

Generate 'n' unique random numbers within a range

Generate 'n' unique random numbers within a range I know how to generate a random number within a range in Python. And I know I can put this in a loop to generate n amount of these numbers However, I ...

23 Oct at 10:35

How do I pass a unique_ptr argument to a constructor or a function?

How do I pass a unique_ptr argument to a constructor or a function? I'm new to move semantics in C++11 and I don't know very well how to handle `unique_ptr` parameters in constructors or functions. Co...

13 Nov at 22:44

How would you make a unique filename by adding a number?

How would you make a unique filename by adding a number? I would like to create a method which takes either a filename as a `string` or a `FileInfo` and adds an incremented number to the filename if t...

14 Jul at 17:46

Unique on a dataframe with only selected columns

Unique on a dataframe with only selected columns I have a dataframe with >100 columns, and I would to find the unique rows by comparing only two of the columns. I'm hoping this is an easy one, but I c...

6 Jan at 23:41

How to select only the first rows for each unique value of a column?

How to select only the first rows for each unique value of a column? Let's say I have a table of customer addresses: ``` +-----------------------+------------------------+ | CName | AddressL...

4 Jan at 20:49

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...

LINQ's Distinct() on a particular property

LINQ's Distinct() on a particular property I am playing with LINQ to learn about it, but I can't figure out how to use [Distinct](https://learn.microsoft.com/en-us/dotnet/api/system.linq.enumerable.di...

18 Jan at 13:19

Laravel migration: unique key is too long, even if specified

Laravel migration: unique key is too long, even if specified I am trying to migrate a users table in Laravel. When I run my migration I get this error: > [Illuminate\Database\QueryException] SQLSTATE...

How can I do SELECT UNIQUE with LINQ?

How can I do SELECT UNIQUE with LINQ? I have a list like this: I am trying to do a SELECT UNIQUE with LINQ, i.e. I want I then changed this to ``` var uniqueColo

2 Sep at 23:34

How can I catch UniqueKey Violation exceptions with EF6 and SQL Server?

How can I catch UniqueKey Violation exceptions with EF6 and SQL Server? One of my tables have a unique key and when I try to insert a duplicate record it throws an exception as expected. But I need to...

How do I count occurrence of unique values inside a list

How do I count occurrence of unique values inside a list So I'm trying to make this program that will ask the user for input and store the values in an array / list. Then when a blank line is entered ...

16 Feb at 20:52