The duplication tag has no wiki summary.
0
votes
0answers
19 views
Duplication Oracle Database to remote host
I have two scenarios.
1 ) Let's say , I have the same file system and same SID on both nodes. I've created any directories necessary for start the duplicate database.
First I used command below.
...
2
votes
2answers
82 views
Duplicating a Database with RMAN
I would like to duplicate to the same server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My database is using SPFILE as shown below.
SQL> SELECT ...
1
vote
1answer
46 views
Summation query with complex grouping criteria
I have a database of coded actions with this structure.
{User, Date, ActionCode}
I need to generate reports based on dates and action codes, and the action codes are not clean because we have to ...
0
votes
1answer
67 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` ...
2
votes
2answers
205 views
How do I remove duplicate records in a join table in PostgreSQL?
I have a table that has a schema like this:
create_table "questions_tags", :id => false, :force => true do |t|
t.integer "question_id"
t.integer "tag_id"
end
...
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 ...
4
votes
1answer
2k views
Optimal way to ignore duplicate inserts?
Background
This problem relates to ignoring duplicate inserts using PostgreSQL 9.2 or greater. The reason I ask is because of this code:
-- Ignores duplicates.
INSERT INTO
db_table ...
5
votes
2answers
102 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
151 views
MySQL check duplicate with group by using wildcard?
+----+--------------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+--------------+-----+-----------+----------+
| 1 | Ramesh Olive | 32 | ...
4
votes
1answer
185 views
Select one name per person where spelling variations exist
I have a source table that contains Employee IDs and names. The employee names may be listed multiple times with variations on the exact spelling (see 'source table' for example - note the middle ...
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
106 views
Right approach to avoid duplicate rows
This for private social network,
so I wonder,
Which approach is more accurate and valid at this time.
So I estimate the tables to have million rows,
First:
CREATE TABLE `system_auth_users` (
...
1
vote
1answer
907 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
363 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
3answers
522 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
151 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
657 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;
...
5
votes
5answers
3k views
How do I copy my SQL Azure database to a local SQL Server instance?
I have an OLTP database hosted on a SQL Azure instance. I want to pull a copy of the database down from the cloud so I can run some heavy extracts and OLAP-style queries against it without impacting ...
5
votes
3answers
482 views
Database replication and consistency check
I got a question about 2 databases (oracle 10g) that I have, let's call them A and B. A have some information(in various tables) and I want B to get a partial copy of some tables from A, and ...
2
votes
1answer
539 views
database duplication VS database replication
Is there a difference between duplication and replication with reference to a database?
I am not sure if I am correct at all, but duplication means to me that we are copying bit by bit without ...
