eng
competition

Text Practice Mode

SQL Practice: Most Common Keywords and Functions

created Dec 12th, 06:45 by IZAKcode


1


Rating

1 words
11 completed
00:00
select from where insert into values update set delete create table drop alter add column join inner left right full outer on group by order asc desc having distinct union all limit offset like in not null is and or between exists case when then else end as primary key foreign references index unique constraint check auto_increment default database if exists truncate view procedure function trigger cascade rollback commit transaction grant revoke user with select count min max avg sum varchar char int float date datetime timestamp boolean blob text select from where insert into values update set delete create table drop alter add column join inner left right full outer on group by order asc desc having distinct union all limit offset like in not null is and or between exists case when then else end as primary key foreign references index unique constraint check auto_increment default database if exists truncate view procedure function trigger cascade rollback commit transaction grant revoke user with select count min max avg sum varchar char int float date datetime timestamp boolean blob text count sum avg min max length round now substring upper lower concat coalesce ifnull group_concat cast convert rand abs floor ceil left right trim replace json_extract json_array_length () ; , update delete from sum varchar case drop insert char exists count where avg text rollback float table right json_extract function blob index timestamp cascade trigger datetime null min add on length commit foreign floor convert coalesce references create left as default abs into order full group trim set user primary check json_array_length replace between procedure avg select int grant view boolean database union revoke key inner desc distinct substring if truncate auto_increment like round sql outer cast now or ceil transaction is max join having limit alter by right upper coalesce concat offset and rand column when values asc truncate exists substring lower unique database floor json_array_length index varchar json_extract trigger rollback char commit truncate cascade references procedure left null min on blob case add int revoke grant function float exists text table count sum from primary trim auto_increment boolean database avg json_extract blob values full lower json_array_length as order delete coalesce limit exists join now inner cascade or rollback text into update count ceil floor references where round concat varchar check date convert offset abs update boolean floor create cascade substring coalesce truncate float full datetime abs procedure trigger case having database json_array_length varchar insert from column select by left text null grant user between references min commit references rand exists database order delete boolean add update sum timestamp varchar json_array_length function drop into floor rollback key column distinct varchar between cascade json_extract index char desc if references now exists procedure union table text references truncate timestamp add ceil json_array_length or varchar

saving score / loading statistics ...