INSERT

Synopsis

INSERT INTO tablename
    attributes VALUES values
    [ THROTTLE throughput ]
INSERT INTO tablename
    items
    [ THROTTLE throughput ]

Examples

INSERT INTO foobars (id) VALUES (1);
INSERT INTO foobars (id, bar) VALUES (1, 'hi'), (2, 'yo');
INSERT INTO foobars (id='foo', bar=10);
INSERT INTO foobars (id='foo'), (id='bar', baz=(1, 2, 3));

Description

Insert data into a table

Parameters

tablename
The name of the table
attributes
Comma-separated list of attribute names
values
Comma-separated list of data to insert. The data is of the form (var [, var]…) and must contain the same number of items as the attributes parameter.
items
Comma-separated key-value pairs to insert.
THROTTLE
Limit the amount of throughput this query can consume. This is a pair of values for (read_throughput, write_throughput). You can use a flat number or a percentage (e.g. 20 or 50%). Using * means no limit (typically useless unless you have set a default throttle in the Options).

See Data Types to find out how to represent the different data types of DynamoDB.