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
or50%
). 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.