MySimpleDB Administrator User Interface

SimpleDB Administrator User Interface

Insert

The Insert operation is a custom utility method that inserts a set of key value pairs, by parsing the insert statement and uses the batchPutAttributes method to insert the key value pairs. Unlike standard SQL, the item name used is also given. If there is already an item name, the key - value pair is added to the item name.

The quoting rules are the same as for the select statement. If no quotes are used, then the value is either a number or an unquoted string.

If the value is a number then Negative Numbers Offsets, Zero Padding algorithms are used. This is a java centric implementation and works for integers (eg. 123), longs (123l), floats (1.23) and doubles (1.23d). Please see Amazon's manual for a more details, or refer to the source of SimpleDBConverter.

 insert into test (`keyone`, keytwo, keythree, keyfour)
values (1.3, 2, 9l, 12.231d)

If no itemName is given then a universally unique identifiers (UUID) is generated for the item name, a guarantee for no collisions of the items inserted:

 insert into test (`keyone`, keytwo) values ('generate
uuid', 'value2a')

The itemName can also be the first column name, this simplifies things when importing the sql into for instance mysql:

 insert into test (`itemName()`, keyone, keytwo)
values ('aItemName', 'value1a', 'value2a')

For the rest the insert is similar to the standard SQL INSERT statement. Example strings follow (no new line characters should be used):

insert into test (keyone, `keytwo`) values ('value1a',
'value2a'), ('value1b5', 'value2b')

Click link to explore

itemName()	hasItems	modifiedTimeMillies	selectStatement
1256901311672	true	1256938628157	select * from not_from_copenhagen
1256901330351	true	1257279703983	select * from test
1256901544224	true	1257365445063	select count(*) from Fips
1256901554977	true	1257379597472	select count(*) from summary_top_pages
1256938667662	true	1257279707861	select * from test WHERE `Chinese` IS NOT NULL ORDER BY `Chinese` ASC
1256938692305	true	1256938692305	delete from test
1256938721127	true	1256938721127	select * from test WHERE `Año` IS NOT NULL ORDER BY `Año` ASC
1256938724463	true	1256938724463	select * from test WHERE `Año` IS NOT NULL AND `Chinese` IS NOT NULL ORDER BY `Chinese` DESC
1256938726699	true	1256938726699	select * from test WHERE `Año` IS NOT NULL AND `Chinese` IS NOT NULL AND `Km` IS NOT NULL ORDER BY `Km` ASC
1256938744411	true	1259004670191	insert into test (key1, key2, newkey1) values (1, 2, 3), (2, 3, 4), item(3, 4, 5), item('string1', 'string2', 'string3')
1256938748410	false	1257283612322	insert into test (newkey1, newkey2) values (1, 2) where key1=1
1256938751735	true	1256938751735	replace into test (key1, key2) values item(5, 6), item1(9,1)
1256938755520	true	1256938755520	replace into test (key1, key2) values (5, 6) where key1=1
1257096257795	true	1257096257795	Select count(*) from Fips
1257096312859	false	1257096312859	Select count(*) from summery_top_pages
1257096409403	true	1257096409403	select Count(*) from summary_top_pages
1257242890023	true	1257379834494	select * from summary_top_pages WHERE itemName() is not null ORDER BY itemName() ASC
1257242895009	true	1257379832310	select * from summary_top_pages WHERE itemName() is not null ORDER BY itemName() DESC
1257242900222	true	1257242900222	select * from summary_top_pages WHERE itemName() is not null AND `anchor_id` IS NOT NULL ORDER BY `anchor_id` ASC
1257242904141	true	1257242904141	select * from summary_top_pages WHERE itemName() is not null AND `anchor_id` IS NOT NULL ORDER BY `anchor_id` DESC
1257242919889	true	1257242919889	select * from summary_top_pages WHERE itemName() is not null AND `anchor_id` IS NOT NULL AND `time_viewed` IS NOT NULL ORDER BY `time_viewed` ASC
1257243083563	true	1257243083563	select count(*) from summary_top_pages where anchor_id like "anchor%"
1257243095115	true	1257243095115	select count(*) from summary_top_pages where anchor_id like "anc%"
1257243105964	true	1257243109797	select count(*) from summary_top_pages where anchor_id like "1%"
1257243191038	true	1257243222430	select * from summary_top_pages WHERE `time_viewed` IS NOT NULL ORDER BY `time_viewed` ASC
1257243198159	true	1257243212554	select * from summary_top_pages WHERE `time_viewed` IS NOT NULL ORDER BY `time_viewed` DESC
1257243246124	true	1257243252995	select count(*) from summary_top_pages WHERE `time_viewed` IS NULL
1257243296451	false	1257243296451	select * from summary_top_pages where anchor_id is like 'anchor_id%'
1257243305665	false	1257243305665	select * from summary_top_pages where anchor_id like 'anchor_id%'
1257243364094	false	1257243364094	select * from summary_top_pages where anchor_id =1
1257243369344	false	1257243369344	select * from summary_top_pages where anchor_id=1
1257243372209	true	1257243386707	select * from summary_top_pages where anchor_id=1l
1257243379840	false	1257243379840	select * from summary_top_pages where anchor_id=2l
1257243383402	false	1257243383402	select * from summary_top_pages where anchor_id=3l
1257243420848	false	1257243420848	select * from summary_top_pages where date_id is like "date_id%"
1257243444928	false	1257243444928	select * from summary_top_pages where date_id like 'date_id%'
1257243478220	false	1257243478220	select * from summary_top_pages where date_id is not null date_id like 'date_id%'
1257243492008	false	1257243492008	select * from summary_top_pages where date_id is not null and date_id like 'date_id%'
1257243527151	false	1257243527151	select * from summary_top_pages where date_id is not null and date_id like "date_id%"
1257243545699	false	1257243545699	select * from summary_top_pages where date_id is not null and date_id
1257243560782	true	1257243560782	select * from summary_top_pages where date_id is not null
1257243610925	false	1257243630609	select * from summary_top_pages where date_id like "date%"
1257243730249	false	1257243730249	select * from summary_top_pages where every(date_id) like "date%"
1257243769639	true	1257243769639	delete from summary_top_pages limit 100
1257243794509	true	1257281170844	delete from summary_top_pages limit 1000
1257243813852	false	1257243813852	delete from summary_top_pages limit 10000
1257244118058	true	1257244118058	select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL ORDER BY `countryCode` ASC
1257244119696	true	1257244119696	select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL AND `regionCode` IS NOT NULL ORDER BY `regionCode` DESC
1257244121299	true	1257244121299	select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL AND `regionCode` IS NOT NULL ORDER BY `regionCode` ASC
1257244122749	true	1257244122749	select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL AND `regionCode` IS NOT NULL AND `regionName` IS NOT NULL ORDER BY `regionName` DESC
1257244165619	true	1257244165619	select * from summary_top_pages where anchor_id like '1%'
1257244170835	false	1257244170835	select * from summary_top_pages where anchor_id like 'a%'
1257244184806	true	1257244184806	select * from summary_top_pages where anchor_id like 'a%' or anchor_id like '1%'
1257244253066	false	1257244253066	select * from summary_top_pages where anchor_id like 'MX%'
1257244326126	true	1257244404370	select * from summary_top_pages WHERE `anchor_id` IS NOT NULL ORDER BY `anchor_id` DESC
1257279467676	true	1257279467676	select * from summary_top_pages where date_id like '0zik%'
1257279510008	false	1257279510008	select * from summary_top_pages where date_id like '%Ö¬Å%'
1257279517688	false	1257279517688	select * from summary_top_pages where date_id like '%Ö%'
1257279522450	false	1257279522450	select * from summary_top_pages where date_id like '%L%'
1257279526764	true	1257279526764	select * from summary_top_pages where date_id like '%p%'
1257279532109	true	1257279532109	select * from summary_top_pages where date_id like '%z%'
1257279625163	false	1257279625163	select * from summary_top_pages where date_id like '%\u221A%'
1257279658809	false	1257279658809	select * from where Chinese like '%中国%'
1257279662945	false	1257279662945	select * from where Chinese like '%中%'
1257279666480	false	1257279666480	select * from where Chinese like '%%'
1257279668886	false	1257279668886	select * from where Chinese like '%'
1257279674174	false	1257279674174	select * from where Chinese like ''
1257279682412	false	1257279682412	select * from where Chinese not like '%'
1257279685640	false	1257279685640	select * from where Chinese not like '1'
1257279692854	false	1257279692854	select * from test where Chinese not like '1'
1257279696287	false	1257279696287	select * from test where Chinese like '1'
1257279732892	true	1257279744086	select * from test WHERE `Chinese` IS NOT NULL and Chinese not like '%bla%'
1257279740246	false	1257279740246	select * from test WHERE `Chinese` IS NOT NULL and Chinese like '%bla%'
1257279751072	true	1257279751072	select * from test WHERE `Chinese` IS NOT NULL and Chinese not like '% 国%'
1257279754758	false	1257279754758	select * from test WHERE `Chinese` IS NOT NULL and Chinese not like '%国%'
1257279758197	true	1257279758197	select * from test WHERE `Chinese` IS NOT NULL and Chinese like '%国%'
1257279849333	false	1257279849333	select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` LIKE '%Å%'
1257279857835	true	1257279857835	select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` NOT LIKE '%Å%'
1257279868197	true	1257279868197	select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` NOT LIKE '%√%'
1257279877281	false	1257279877281	select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` LIKE '%√%'
1257279904134	false	1257279904134	select * from summary_top_pages WHERE `null_time_views` LIKE '%√%'
1257279915859	true	1257279915859	select * from summary_top_pages WHERE `null_time_views` NOT LIKE '%√%'
1257279947047	true	1257279947047	select * from summary_top_pages WHERE `null_time_views` NOT LIKE '%Ö%'
1257279955309	false	1257279955309	select * from summary_top_pages WHERE `null_time_views` LIKE '%Ö%'
1257279964543	false	1257279964543	select * from summary_top_pages WHERE `null_time_views` LIKE "%Ö%"
1257280019446	true	1257280019446	select * from summary_top_pages WHERE `date_id` NOT LIKE '%Ö%'
1257280027855	true	1257280027855	select * from summary_top_pages WHERE `date_id` LIKE '%Ö%'
1257280834008	true	1257280862214	select * from summary_top_pages WHERE `anchor_id` LIKE '%Ł%'
1257280847473	false	1257280847473	select * from summary_top_pages WHERE `anchor_id` NOT LIKE '%Ł%'
1257280881733	true	1257280881733	select * from summary_top_pages WHERE every(`anchor_id`) LIKE '%Ł%'
1257280894268	false	1257280894268	select * from summary_top_pages WHERE every(`anchor_id`) NOT LIKE '%Ł%'
1257280904835	false	1257280904835	select * from summary_top_pages WHERE every(`anchor_id`) NOT LIKE '%Ł'
1257280912494	true	1257281036548	select * from summary_top_pages WHERE every(`anchor_id`) LIKE '%Ł'
1257280921508	false	1257280921508	select * from summary_top_pages WHERE NOT every(`anchor_id`) LIKE '%Ł'
1257281051740	true	1257281344373	select count(*) from summary_top_pages WHERE every(`anchor_id`) LIKE '%Ł'
1257281197836	true	1257281269601	delete from summary_top_pages limit 2500
1257281280407	true	1257281280407	delete from summary_top_pages limit 527
1257281318504	true	1257281318504	select * from summary_top_pages WHERE `anchor_id` IS NOT NULL AND `root_url_id` IS NOT NULL ORDER BY `root_url_id` DESC
1257281323685	true	1257281323685	select * from summary_top_pages WHERE `anchor_id` IS NOT NULL AND `root_url_id` IS NOT NULL ORDER BY `root_url_id` ASC
1257360862579	true	1257361402589	select * from Question

itemName()

hasItems

modifiedTimeMillies

selectStatement

1256901311672

true

1256938628157

select * from not_from_copenhagen

1256901330351

true

1257279703983

select * from test

1256901544224

true

1257365445063

select count(*) from Fips

1256901554977

true

1257379597472

select count(*) from summary_top_pages

1256938667662

true

1257279707861

select * from test WHERE `Chinese` IS NOT NULL ORDER BY `Chinese` ASC

1256938692305

true

1256938692305

delete from test

1256938721127

true

1256938721127

select * from test WHERE `Año` IS NOT NULL ORDER BY `Año` ASC

1256938724463

true

1256938724463

select * from test WHERE `Año` IS NOT NULL AND `Chinese` IS NOT NULL ORDER BY `Chinese` DESC

1256938726699

true

1256938726699

select * from test WHERE `Año` IS NOT NULL AND `Chinese` IS NOT NULL AND `Km` IS NOT NULL ORDER BY `Km` ASC

1256938744411

true

1259004670191

insert into test (key1, key2, newkey1) values (1, 2, 3), (2, 3, 4), item(3, 4, 5), item('string1', 'string2', 'string3')

1256938748410

false

1257283612322

insert into test (newkey1, newkey2) values (1, 2) where key1=1

1256938751735

true

1256938751735

replace into test (key1, key2) values item(5, 6), item1(9,1)

1256938755520

true

1256938755520

replace into test (key1, key2) values (5, 6) where key1=1

1257096257795

true

1257096257795

Select count(*) from Fips

1257096312859

false

1257096312859

Select count(*) from summery_top_pages

1257096409403

true

1257096409403

select Count(*) from summary_top_pages

1257242890023

true

1257379834494

select * from summary_top_pages WHERE itemName() is not null ORDER BY itemName() ASC

1257242895009

true

1257379832310

select * from summary_top_pages WHERE itemName() is not null ORDER BY itemName() DESC

1257242900222

true

1257242900222

select * from summary_top_pages WHERE itemName() is not null AND `anchor_id` IS NOT NULL ORDER BY `anchor_id` ASC

1257242904141

true

1257242904141

select * from summary_top_pages WHERE itemName() is not null AND `anchor_id` IS NOT NULL ORDER BY `anchor_id` DESC

1257242919889

true

1257242919889

select * from summary_top_pages WHERE itemName() is not null AND `anchor_id` IS NOT NULL AND `time_viewed` IS NOT NULL ORDER BY `time_viewed` ASC

1257243083563

true

1257243083563

select count(*) from summary_top_pages where anchor_id like "anchor%"

1257243095115

true

1257243095115

select count(*) from summary_top_pages where anchor_id like "anc%"

1257243105964

true

1257243109797

select count(*) from summary_top_pages where anchor_id like "1%"

1257243191038

true

1257243222430

select * from summary_top_pages WHERE `time_viewed` IS NOT NULL ORDER BY `time_viewed` ASC

1257243198159

true

1257243212554

select * from summary_top_pages WHERE `time_viewed` IS NOT NULL ORDER BY `time_viewed` DESC

1257243246124

true

1257243252995

select count(*) from summary_top_pages WHERE `time_viewed` IS NULL

1257243296451

false

1257243296451

select * from summary_top_pages where anchor_id is like 'anchor_id%'

1257243305665

false

1257243305665

select * from summary_top_pages where anchor_id like 'anchor_id%'

1257243364094

false

1257243364094

select * from summary_top_pages where anchor_id =1

1257243369344

false

1257243369344

select * from summary_top_pages where anchor_id=1

1257243372209

true

1257243386707

select * from summary_top_pages where anchor_id=1l

1257243379840

false

1257243379840

select * from summary_top_pages where anchor_id=2l

1257243383402

false

1257243383402

select * from summary_top_pages where anchor_id=3l

1257243420848

false

1257243420848

select * from summary_top_pages where date_id is like "date_id%"

1257243444928

false

1257243444928

select * from summary_top_pages where date_id like 'date_id%'

1257243478220

false

1257243478220

select * from summary_top_pages where date_id is not null date_id like 'date_id%'

1257243492008

false

1257243492008

select * from summary_top_pages where date_id is not null and date_id like 'date_id%'

1257243527151

false

1257243527151

select * from summary_top_pages where date_id is not null and date_id like "date_id%"

1257243545699

false

1257243545699

select * from summary_top_pages where date_id is not null and date_id

1257243560782

true

1257243560782

select * from summary_top_pages where date_id is not null

1257243610925

false

1257243630609

select * from summary_top_pages where date_id like "date%"

1257243730249

false

1257243730249

select * from summary_top_pages where every(date_id) like "date%"

1257243769639

true

1257243769639

delete from summary_top_pages limit 100

1257243794509

true

1257281170844

delete from summary_top_pages limit 1000

1257243813852

false

1257243813852

delete from summary_top_pages limit 10000

1257244118058

true

1257244118058

select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL ORDER BY `countryCode` ASC

1257244119696

true

1257244119696

select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL AND `regionCode` IS NOT NULL ORDER BY `regionCode` DESC

1257244121299

true

1257244121299

select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL AND `regionCode` IS NOT NULL ORDER BY `regionCode` ASC

1257244122749

true

1257244122749

select * from Fips WHERE itemName() is not null AND `countryCode` IS NOT NULL AND `regionCode` IS NOT NULL AND `regionName` IS NOT NULL ORDER BY `regionName` DESC

1257244165619

true

1257244165619

select * from summary_top_pages where anchor_id like '1%'

1257244170835

false

1257244170835

select * from summary_top_pages where anchor_id like 'a%'

1257244184806

true

1257244184806

select * from summary_top_pages where anchor_id like 'a%' or anchor_id like '1%'

1257244253066

false

1257244253066

select * from summary_top_pages where anchor_id like 'MX%'

1257244326126

true

1257244404370

select * from summary_top_pages WHERE `anchor_id` IS NOT NULL ORDER BY `anchor_id` DESC

1257279467676

true

1257279467676

select * from summary_top_pages where date_id like '0zik%'

1257279510008

false

1257279510008

select * from summary_top_pages where date_id like '%Ö¬Å%'

1257279517688

false

1257279517688

select * from summary_top_pages where date_id like '%Ö%'

1257279522450

false

1257279522450

select * from summary_top_pages where date_id like '%L%'

1257279526764

true

1257279526764

select * from summary_top_pages where date_id like '%p%'

1257279532109

true

1257279532109

select * from summary_top_pages where date_id like '%z%'

1257279625163

false

1257279625163

select * from summary_top_pages where date_id like '%\u221A%'

1257279658809

false

1257279658809

select * from where Chinese like '%中国%'

1257279662945

false

1257279662945

select * from where Chinese like '%中%'

1257279666480

false

1257279666480

select * from where Chinese like '%%'

1257279668886

false

1257279668886

select * from where Chinese like '%'

1257279674174

false

1257279674174

select * from where Chinese like ''

1257279682412

false

1257279682412

select * from where Chinese not like '%'

1257279685640

false

1257279685640

select * from where Chinese not like '1'

1257279692854

false

1257279692854

select * from test where Chinese not like '1'

1257279696287

false

1257279696287

select * from test where Chinese like '1'

1257279732892

true

1257279744086

select * from test WHERE `Chinese` IS NOT NULL and Chinese not like '%bla%'

1257279740246

false

1257279740246

select * from test WHERE `Chinese` IS NOT NULL and Chinese like '%bla%'

1257279751072

true

1257279751072

select * from test WHERE `Chinese` IS NOT NULL and Chinese not like '% 国%'

1257279754758

false

1257279754758

select * from test WHERE `Chinese` IS NOT NULL and Chinese not like '%国%'

1257279758197

true

1257279758197

select * from test WHERE `Chinese` IS NOT NULL and Chinese like '%国%'

1257279849333

false

1257279849333

select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` LIKE '%Å%'

1257279857835

true

1257279857835

select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` NOT LIKE '%Å%'

1257279868197

true

1257279868197

select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` NOT LIKE '%√%'

1257279877281

false

1257279877281

select * from summary_top_pages WHERE `null_time_views` IS NOT NULL AND `null_time_views` LIKE '%√%'

1257279904134

false

1257279904134

select * from summary_top_pages WHERE `null_time_views` LIKE '%√%'

1257279915859

true

1257279915859

select * from summary_top_pages WHERE `null_time_views` NOT LIKE '%√%'

1257279947047

true

1257279947047

select * from summary_top_pages WHERE `null_time_views` NOT LIKE '%Ö%'

1257279955309

false

1257279955309

select * from summary_top_pages WHERE `null_time_views` LIKE '%Ö%'

1257279964543

false

1257279964543

select * from summary_top_pages WHERE `null_time_views` LIKE "%Ö%"

1257280019446

true

1257280019446

select * from summary_top_pages WHERE `date_id` NOT LIKE '%Ö%'

1257280027855

true

1257280027855

select * from summary_top_pages WHERE `date_id` LIKE '%Ö%'

1257280834008

true

1257280862214

select * from summary_top_pages WHERE `anchor_id` LIKE '%Ł%'

1257280847473

false

1257280847473

select * from summary_top_pages WHERE `anchor_id` NOT LIKE '%Ł%'

1257280881733

true

1257280881733

select * from summary_top_pages WHERE every(`anchor_id`) LIKE '%Ł%'

1257280894268

false

1257280894268

select * from summary_top_pages WHERE every(`anchor_id`) NOT LIKE '%Ł%'

1257280904835

false

1257280904835

select * from summary_top_pages WHERE every(`anchor_id`) NOT LIKE '%Ł'

1257280912494

true

1257281036548

select * from summary_top_pages WHERE every(`anchor_id`) LIKE '%Ł'

1257280921508

false

1257280921508

select * from summary_top_pages WHERE NOT every(`anchor_id`) LIKE '%Ł'

1257281051740

true

1257281344373

select count(*) from summary_top_pages WHERE every(`anchor_id`) LIKE '%Ł'

1257281197836

true

1257281269601

delete from summary_top_pages limit 2500

1257281280407

true

1257281280407

delete from summary_top_pages limit 527

1257281318504

true

1257281318504

select * from summary_top_pages WHERE `anchor_id` IS NOT NULL AND `root_url_id` IS NOT NULL ORDER BY `root_url_id` DESC

1257281323685

true

1257281323685

select * from summary_top_pages WHERE `anchor_id` IS NOT NULL AND `root_url_id` IS NOT NULL ORDER BY `root_url_id` ASC

1257360862579

true

1257361402589

select * from Question