Tagged Questions
0
votes
1answer
79 views
On duplicate key do nothing
I am inserting into the following table using LuaSQL with PtokaX API.
CREATE TABLE `requests` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`ctg` VARCHAR(15) NOT NULL,
`msg` ...
0
votes
0answers
40 views
row locking or avoiding duplicate insertion on primarykey/otherfield combo
i have a table that stores additional data pertaining to files/images saved in files elsewhere, each entry can be associated with another type in the system,
for users there may be one or more ...
5
votes
2answers
103 views
Resolving DUPLICATE for a column with UNIQUE
I have a few column with UNIQUE INDEX. In some queries, duplicates should be acceptable, in which a postfix should be added to the value. For example, if test title exits, we change it to test ...
4
votes
2answers
154 views
MySQL check duplicate with group by using wildcard?
+----+--------------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+--------------+-----+-----------+----------+
| 1 | Ramesh Olive | 32 | ...
1
vote
2answers
1k views
remove duplicate rows in mysql table that does not contain primary key
I have a table item having just one column name:-
name
-----
toys
shirt
mobile
Shirt
speaker
Toys
....
....
I am trying to delete duplicate rows except one duplicated record with the help of below ...
1
vote
1answer
960 views
How to use ON DUPLICATE KEY for UPDATE
Consider a table of
CREATE TABLE test
(
id int(11) unsigned NOT NULL AUTO_INCREMENT,
external_id int(11),
number smallint(5),
value varchar(255),
UNIQUE INDEX (external_id, number),
PRIMARY KEY(id)
...
2
votes
1answer
151 views
Check against multiple duplicate records
I have data that i should insert into table.
But before inserting i need to check against duplicate records and report list of those records.
Table:
CREATE TABLE `test` (
`A` varchar(19) NOT NULL,
...
3
votes
1answer
372 views
Getting duplicate primary key for auto increment coloumn
I have a MySQL Innodb table with 'id' as auto increment primary key coloumn.
My Scripts are doing following operations:
insert ignore into tablename set x='a', y='b'
update ignore tablename set ...
2
votes
4answers
555 views
Two-sided UNIQUE INDEX for two columns
Creating a table with composite PRIMARY KEY or using UNIQUE INDEX for two columns guarantee uniqueness of col1, col2. Is there a tricky approach to make the reverse order of two columns UNIQUE too ...
4
votes
1answer
152 views
Need to find duplicate entries
I received a database with a few million records in it, but apperently there might be duplicate records in them.
A user enters data into the database and a primary key is generated, however if the ...
1
vote
1answer
120 views
MySQL detect duplicate human names [closed]
I've been tasked with identifying a solution to help identify possible duplicates when inserting new user records into a MySQL database. Does anyone know of any cheap, preferably free, solutions?
The ...
1
vote
1answer
663 views
Duplicate entry in mysql
I have a mysql master-slave replication setup. when I checked "show slave status", I got the result as "Slave_Sql_running:No" and Last error as "Duplicate entry 'x' on query."
But when I tried to ...
1
vote
2answers
2k views
Deleting duplicates with group by and count
What is the fastest method to convert the following query:
SELECT COUNT(*) as c FROM tbl_fields
WHERE fieldnotes IS NULL
GROUP BY fieldno,fieldserial,id,fielddate,fieldsid
HAVING COUNT(*) > 1;
...
