5 lines
262 B
Text
5 lines
262 B
Text
CREATE TABLE associative_array (KEY_COLUMN VARCHAR, VALUE_COLUMN VARCHAR);
|
|
# Insert a Key Value pair
|
|
INSERT INTO associative_array VALUES ('KEY', 'VALUE');
|
|
# Retrieve a key value pair
|
|
SELECT aa.value_column FROM associative_array aa where aa.key_column = 'KEY';
|