|
1878.5.4
by Brian Aker
Update documentation. |
1 |
Replacing Data
|
|
1900.2.6
by Stewart Smith
fix docs warning: underline/overline too short for replace.rst |
2 |
==============
|
|
1878.5.4
by Brian Aker
Update documentation. |
3 |
|
4 |
In Dizzle you can make use of REPLACE to insert a new record into a table or |
|
5 |
delete and insert a record in a table if a record matching the primary key |
|
6 |
already exists. If no primary key or unique constraint is found on the table |
|
7 |
then REPLACE is equivalent to INSERT. |
|
8 |
||
9 |
A typical query: |
|
10 |
||
11 |
REPLACE INTO table_1 SET a=5; |
|
12 |
||
13 |
or |
|
14 |
||
15 |
REPLACE INTO table_1 VALUES (4); |
|
16 |
||
17 |
||
18 |
REPLACE is an extension to the SQL Standard that firtst appeared in MySQL. |