Saturday, 20 January 2018  
 
Dolvin Blog
Dolvin Blog » Our DB
Replace Into - MySql Query
by. Dolvin ≈ August 2, 2008
I like using this syntax in MySql coz it have a simple syntax and so efficient when I want to insert a record but if it already exist, it'll update the data... 
but it not too recommended, coz from the statement below.. REPLACE INTO will slower the performer...

Mechanism ::

   1. Try to insert the new row into the table
   2. While the insertion fails because a duplicate-key error occurs for a primary key or unique index:
         1. Delete from the table the conflicting row that has the duplicate key value
         2. Try again to insert the new row into the table

Syntac ::
REPLACE INTO F SELECT * FROM T;
REPLACE INTO F(a, b, c) SELECT a, b, c FROM T;
Summary:
REPLACE INTO becomes more efficient from DELETE FROM… INSERT INTO… but  much slower performer than an UPDATE statement. Better use “INSERT … ON DUPLICATE KEY UPDATE…” as an alternative if you’re looking at a single unique column table (Primary Key).

source : http://blog.sherlock-group.com
 
<< back to Dolvin's Blog




:: January '18 ::
 
 
S
M
T
W
T
F
S
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
   

:: My Blog List ::
 
   
   

:: Blog Category ::
 
 
» Books
» Christian Soul
» Fashion
» Film
» Foods & Drinks
» Games
» General Info
» Health
» Jokes
» Love
» Music
» My Life
» Programming
» Technology
 
   

:: Site Links ::
 
 
» Angel Sulistyo
» Anton Ongsono
» Darwin
» Fellys
» Inge
» Kado Imut
» Koleksi Unik
» Lie Fung
» Lintaka
» Lobak
» Rosrita
 
   
 
:: Dolvin Website | Dolvin Blog | Our DB ::
Copyright © Lavinia - 2006 - 2018