1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
Replacing Data
==============
In Dizzle you can make use of REPLACE to insert a new record into a table or
delete and insert a record in a table if a record matching the primary key
already exists. If no primary key or unique constraint is found on the table
then REPLACE is equivalent to INSERT.
A typical query:
.. code-block:: mysql
REPLACE INTO table_1 SET a=5;
or
.. code-block:: mysql
REPLACE INTO table_1 VALUES (4);
REPLACE is an extension to the SQL Standard that first appeared in MySQL.
|