I have one
UNIQUE field in my table, and I need to search over it quickly. Do I need to index it?
I have one
I have a table for storing coupons/discounts, and I want to use the coupon_code column as the primary key, which is a
I’ve got an error on MySQL while trying to add a UNIQUE KEY. Here’s what I’m trying to do. I’ve got a column called ‘unique_id’ which is VARCHAR(100). There are no indexes defined on the table. I’m getting this error:
i have a column ID and something like 1000 items, some of then were removed like
id=90, id=127, id=326
I saw some other questions related to this, but they were not MySQL.
How can I efficiently create a unique index on two fields in a table like this:
create table t (a integer, b integer);
I can’t seem to figure this out so far. I am trying to join two tables and only select the rows in table A that do not have a matching column in table B. For example, lets assume we have a users table and a sent table.
Are indices (indexes) defined as UNIQUE case sensitive in MySQL?
I’m using MySql 5.5.37. I have a table with the following columns
Given this data set: